SQL Server 系统实用指令

sp_who2: 查看当前连接到系统的帐户

 

 

 

透视表查询的例子

--ProductID OrderMonth SubTotal
--1 5 100.00
--1 6 100.00
--2 5 200.00
--2 6 200.00
--2 7 300.00
--3 5 400.00
--3 5 400.00
--

create table T1(ProductID int ,OrderMonth int,SubTotal int)

insert into T1 select 1,5,100
union all select 1,6,100
union all select 2,5,200
union all select 2,6,200
union all select 2,7,300
union all select 3,5,400
union all select 3,5,400

 select * from T1

select ProductID ,[5] [五月],[6] [六月],[7] [七月] from T1
pivot
(sum(SubTotal)
for OrderMonth in ([5],[6],[7])) as p

drop table T1