T-SQL 操作XML示例
摘要：看MSND好长CREATETABLEXMLTable(IDintprimarykey,Dataxml,)INSERTINTOXMLTable(ID,Data)Values(1,'<entity><id>1</id><name>name</name></entity>')SelectData.query('/entity/name/text()')FROMXMLTableWHEREData.value('(/entity/id)[1]','int')=1--Pe
阅读全文
posted @ 2011-11-29 20:06
