Does anyone know how to pass a XML File to a MS SQL 2005 Stored Procedure (INSERT/UPDATE), and how to create the stored procedure so it will accept the XML values using VB 2005.
Here is an example of the XML File.
Code:
<MYROOT>
<TableName>
<Field1>String</Field1>
<Field2>String</Field2>
<Field3>String</Field3>
</TableName>
</MYROOT>
Thank you.
bty The following link provided by Microsoft does not work in VB 2005, I have tried that
http://support.microsoft.com/default.aspx scid=kb;en-us;555266
Pass XML Data to a Stored Procedure
Finzzownt
Also check out Sushil's weblog on this ->
http://blogs.msdn.com/sushilc/archive/2004/08/03/207162.aspx
This explains the basics of sending XML to SQL 2005 as a parameter.
Kathleen McGrath - MSFT
You can do this using XQuery to strip the values and pass them to the stored proc. You can view a good article on using XQuery here:
http://www.15seconds.com/issue/050803.htm
***
Download this free script (WSP Snapshot 1.0) to take snapshot sample of your web server(s) from anywhere/anytime using a browser. View the stats (cpu and disk stress, available memory, requests queued, request wait time and more) on a cellphone or PDA also. http://www.ifusionsoft.com