sql xml
摘要:
DECLARE @xml XML;SET @xml = 'ZBProductProfitsLossesTwo110';create table #pp( name nvarchar(50), value nvarchar(50), Direction nvarchar(50))insert into #ppSELECT '@' + v.value('(@name)[1]', 'nvarchar(50)') AS NAME ,v.value('(.)[1]', 'nvarchar(50)') AS v 阅读全文
posted @ 2013-07-02 17:27 RedFox(低调) 阅读(252) 评论(0) 推荐(0) 编辑