【SQL行转列】
_____________________________________________________________________________________
声明:此文摘自网络,仅供学习研究之用.
declare @sql nvarchar(4000)
set @sql='Select 姓名 '
Select @sql=@sql+',sum(case when CId='+convert(varchar,CId)+ ' then 成绩 else 0 end) As '''+CName+''''
From 课程表
Print @sql
set @sql=@sql+' From 成绩表 Group By 姓名'
--Print @sql
execute sp_executesql @sql
_____________________________________________________________________________________
COPYRIGHT©2008,HTTP://ZEROBUG.CNBLOGS.COM .ALL RIGHTS RESERVED.
COPYRIGHT©2008,HTTP://ZEROBUG.CNBLOGS.COM .ALL RIGHTS RESERVED.