Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-06 : 10:13:37
|
| Metehan writes "How can i query xml data sit on one of my table's column as texti have this xmldata about 18k and i would like to query this xmldata to findout certain element which match @arg that i pass" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-06 : 20:19:27
|
[url]http://sqlxml.org/faqs.aspx?faq=42[/url]If you use SQLXML a lot then this site is a must [url]http://sqlxml.org[/url]SQLXML is really a client technology and server side XML handling , especially interim result sets are poor currently ,but they can only get better  HTHJasper Smith |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-06-06 : 21:02:54
|
| Metehan,You are venturing into dangerous territory mixing a relational data model with a hierarchy data model.The battle between hierarchy and relational was won in the mid 70's by the relational model. "Those who don't study history are doomed to repeat it."Good luck!DavidM"SQL-3 is an abomination.." |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-06 : 21:48:56
|
Your gonna love Yukon then Writing that first proc in C# using XQuery (or XPath/OPath or whatever it will be called next week) and ObjectSpaces is gonna be fun |
|
|
|
|
|
|
Querying xmldata on sql2000