realcoding
asked on
need a good xml format to use as stored proc input
i have a stored proc that takes an xml string that is like <param @operation="ins" @data="test" />
but using this is problematic because i cant validate any params as they are all strings...
using sql parameters would have at least given me strong data types...
im lookign to regain this by using an xml like this and want to know how to extract the xml data for use in my stored procs and to come up with a simple xml layout to make extracting the data from the xml simple in SQL proc.
but using this is problematic because i cant validate any params as they are all strings...
using sql parameters would have at least given me strong data types...
im lookign to regain this by using an xml like this and want to know how to extract the xml data for use in my stored procs and to come up with a simple xml layout to make extracting the data from the xml simple in SQL proc.
<param>
<operation>ins</operation>
<data>some data here</data>
</param>
ASKER
anyone with more insight than a link?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://blog.sqlauthority.com/2009/02/13/sql-server-simple-example-of-reading-xml-file-using-t-sql/