SQL行转列,透析转换(Pivoting)
摘要:
建表,插入数据create table PayPhoneMoney(id int identity(1,1) primary key,userName nvarchar(50),payType nvarchar(20), [money] decimal(9,2),payTime datetime)goinsert into PayPhoneMoney values('小李','支付宝',20,'2012-01-03')insert into PayPhoneMoney values('小陈','工行',20, 阅读全文
posted @ 2012-02-06 11:15 Catherine# 阅读(273) 评论(0) 推荐(0)
浙公网安备 33010602011771号