Hi all,I came across the below SQLServer stored procedure, I understand that it manipulates some XML data, but am not sure what it does.. Could any one pls explain me on the below procedure,Also, i do not see 'values' clause in the insert statement in the below procedure, is it valid to use in this way? (as per the syntax, 'values' clause is NOT optional)CREATE PROCEDURE [dbo].[OM_addObjData] @xml_Doc_sample varchar(max), @objID intASBEGIN --set @xml_Doc_sample = '<?xml version="1.0" encoding="utf-8"?><ArrayOfEXEData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><EXEData><EXEName>exeName</EXEName><EXECommand>exeCommand</EXECommand></EXEData></ArrayOfEXEData>' declare @docIdx int EXECUTE sp_xml_preparedocument @docIdx OUTPUT, @xml_Doc_sample insert into OM_EXE select @objID, exeName, exeCommand, IdEXE, EXE From OPENXML(@docIdx, N'/ArrayOfEXEData/EXEData', 2) With OM_EXE EXECUTE sp_xml_removedocument @docIdxEND
Thanks in advance,SnToday will be yesterday tomorrow, Do it now..
need help on SP using XML related functions
Posted - 2007-04-20 : 01:52:27
