---行转列--pivotcreate table tempTable( id int primary key identity(1,1), Student nvarchar(36), [Subject] nvarchar(36), Score int,)select * from tempTableinsert into tempTable values
如下：drop table tempdatedeclare @sdate datetimedeclare @endtime datetimeset @sdate = '2000/1/1'set @endtime='2015/1/31'select DATEADD(dd,ROW_NUMBER() over( order by ''),@sdate) as date into tempda
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
