Group: microsoft.public.sqlserver.xml · Group Profile · Search for Testtext in microsoft.public.sqlserver.xml
Author: Merijn
Date: Feb 23, 2007 05:42
...Load and parse the XML document in Memory EXEC sp_xml_preparedocument @idoc OUTPUT select * from testtext where id=3 for xml auto exec testXMLInsert @idoc --now clear the XML ... SP 2 CREATE PROCEDURE [dbo].[testXMLInsert] @idoc as int AS insert into testtext (test) select test from openxml(@idoc,'/testtext',0) WITH (id int, test text) GO My Idea was to parse the handle to the XML ...
|