how select and update delete data form xml
XML / XSL
1
Posts
1
Posters
0
Views
1
Watching
-
i am using this code required result is not obtained DECLARE @DataColumnListInXML XML SELECT @DataColumnListInXML=' 1 1 2 DECLARE @IColumnList int --Create an internal representation of the XML document. EXEC sp_xml_preparedocument @IColumnList OUTPUT, @DataColumnListInXML SELECT featureID,ID FROM OPENXML (@IColumnList, '/ColumnFeature/Feature/Columns',3) WITH (ID varchar(19), featureID varchar(19) )
hi