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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2010-09-09 : 18:58:52
|
hi thereI am having issues with & in my xml strem when trying to do SELECT t.u.value('x[1]','varchar(max)') as x FROM @xml.nodes('/root/x/y)t(u)Are there any other values that xml does not like that I need to handle. If so how do I do that?ThanksIf you don't have the passion to help people, you have no passion |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-09-10 : 00:48:24
|
You can use the TYPE predicate.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-09-10 : 00:48:49
|
You can also check my blog for XML entitization.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
xml parsing