行列转换写法小结(二)
(2) 动态
declare @sql varchar(8000)
select @sql = isnull(@sql + '],[' , '') + name from syscolumns
where name <> N'ID' and ID = object_id('ColToRow')
set @sql = '[' + @sql + ']'
--print @sql
exec('select ID , Code , Value from ColToRow unpivot (Value for Code in(' + @sql + ')) t')