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 |
|
sital
Yak Posting Veteran
89 Posts |
 Posted - 2009-01-10 : 11:37:33
|
| What does assdesc mean in the following query?select assdesc.query('/shipto[Address = 18]') from h2Why should we write it in the query?Thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-10 : 12:07:29
|
| http://www.15seconds.com/Issue/050803.htm |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-10 : 14:07:28
|
| assdesc is an xml type column. what you're trying is query above is to use query() method to extract data from xml column assdesc using specificed xpath value. |
|
|
|
|
|
|
Urgent pls.