How to access xml tag in sql server column
-
Hello, I'm using SQL Server 2005. I have a column named "DATA" with ntext datatype that stores xml data which contains these tags: Text Free Meal Thank you for participating. Just present this [MCCode] to claim your free meal. How do I use sql select statement to access and return the string "Thank you for participating..." as a result? Thank you.:~ :->:-O
-
Hello, I'm using SQL Server 2005. I have a column named "DATA" with ntext datatype that stores xml data which contains these tags: Text Free Meal Thank you for participating. Just present this [MCCode] to claim your free meal. How do I use sql select statement to access and return the string "Thank you for participating..." as a result? Thank you.:~ :->:-O
Although I've not had a chance to use it yet, isn't that what the new XML datatype is for?
Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog