October 12, 2007 at 7:17 am
I am relatively new to SQL 2005 and I am wondering how or if anyone is using the XML Data Type as a column. Where does it make sense and why? Most of the use of the XML Type that I have seen has been using it as a stored procedure parameter when you have 1 to N parameters to be passed in or when passing in a list of values.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 12, 2007 at 8:34 am
We are using it in some places. The purpose is pretty much self-explanatory, we want to persist XML data and having an XML data type for storage ensures that we're only storing well formed XML. We haven't been using the facility to attach a schema to the column to precisely verify the structure of the XML, but we're looking into it. So far, knock wood, it's been nothing but a benefit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 12, 2007 at 9:18 am
Thanks Grant. Are you searching/querying against the XML column? Do you return the data in the XML column as rows and columns or just as XML?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 12, 2007 at 9:32 am
No, we're not searching against it. We simply return it as XML. I have looked into using the XML indexes, but that nine times data storage that I keep reading about has pretty much turned me off.
We also use XML for batch inserts & updates which we shred using OPENXML. So far, that's pretty much it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply