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.
<data>some data here</data>