摘要：从表里面导出数据XML：-- exportdeclare @xml xml set @xml = (select * from (select TableName = 'Schema', xmlData = ( select * from [Schema] where id = 337... 阅读全文
SQL XML process
2015-03-30 16:02 by caixia9, 182 阅读, 0 推荐, 收藏, 编辑
摘要：declare @data xmlset @data=' Everyday Italian Giada De Laurentiis 2005 30.00 Harry Potter J K. Rowling 2005 29.99 XQuery Kick Start James Mc... 阅读全文
SQL Convert XML to Table
2015-03-30 14:17 by caixia9, 1866 阅读, 0 推荐, 收藏, 编辑
摘要：将xml nodes 属性中的值 转为table 形式 declare @xml2 xml set @xml2 = ' ' select S.value('@CmaName', 'varchar(36)') as CmaName , S.value('@Cma... 阅读全文