10 2015 档案

Sql 竖表转横表
摘要：declare @sql varchar(8000)set @sql='select t3.BID,t5.UnitName,Sort,UnitTypeSort'select @sql=@sql+' , max(case t4.id when '''+ ID +''' then t3.Num else... 阅读全文
posted @ 2015-10-09 15:01 sulin 阅读(358) 评论(0) 推荐(0)