Open Xml Document in Store Procedure for bulk update?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1336
sp_helptext DeleteCmsComplianceType_Sp

CREATE PROCEDURE DeleteCmsComplianceType_Sp
(
@rtnVal int,
@xmlCTypeId nvarchar(max)
)
AS
BEGIN
DECLARE @hdoc1 int
EXEC sp_xml_preparedocument @hdoc1 OUTPUT, @xmlCTypeId

Insert into T1SP1(id,name) select * from OPENXML(@index, '/data/ids') WITH (id INT,name varchar(50))
EXEC sp_xml_removedocument @hdoc1
set @rtnVal=1
END
return @rtnVal


Comments or Responses

Login to post response