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 |
|
NyiNyi
Starting Member
3 Posts |
 Posted - 2012-03-11 : 03:59:21
|
| Hi, I would like to retrieve data from xml data type of SQL table. I want to get the Product Type and SN No. How to retrieve from my SQL Table of XML DataType?. The Product_Type and SN no may be more...<data><tmp id ="CL1"><repeat seq ="1"><item id ="A"><value>01/02/12</value></item><tmp id ="A1><repeat seq="1"><item Id ="SN"><value>1</value></item><item Id="Product_Type"><value>A</value></item></repeat><repeat seq="2"><item Id ="SN"><value>2</value></item><item Id="Product_Type"><value>B</value>Please give me advice.. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-11 : 06:59:09
|
| Open up Books Online and read up on the XQuery functions query and value, also the table-valued function nodes.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Retrieve Data from XML DataType In MSSQL