top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to send a full class into the stored procedure in the form of XML?

+1 vote
254 views
How to send a full class into the stored procedure in the form of XML?
posted Dec 26, 2013 by Vishvachi Tiwari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

You can use xml data type as parameter in the sp.

.AddParam("Name ofParameter",size,me.xml("className")) // from backgroun coding

declare @handle int
declare @XML xml = '2013-01-012013-01-02'
exec sp_xml_preparedocument @handle out, @XML
select * from openxml(@handle, '/ROOT/ids', 2) with (id Date)
exec sp_xml_removedocument @handle

answer Dec 26, 2013 by Atul Mishra
...