简单但有用的SQL脚本.docVIP

行列互转create?table?test(id?int,name?varchar(20),quarter?int,profile?int)?insert?into?test?values(1,a,1,1000)insert?into?test?values(1,a,2,2000)insert?into?test?values(1,a,3,4000)insert?into?test?values(1,a,4,5000)insert?into?test?values(2,b,1,3000)insert?into?test?values(2,b,2,3500)insert?into?test?values(2,b,3,4200)insert?into?test?values(2,b,4,5500)select?*?from?test--行转列select?id,name,[1]?as?一季度,[2]?as?二季度,[3]?as?三季度,[4]?as?四季度,[5]?as?5fromtestpivot(sum(profile)for?quarter?in([1],[2],[3],[4],[5]))as?pvtcreate?table?test2(id?int,name?varchar(20),?Q1?int,?Q2?int,?Q3