tsql使用小记20100127
Insert into 的写法
INSERT INTO dbo . DM_T_RWX_UserProductSerialCodeInfo ( userid , ProductSerialCode , count ) SELECT TOP 10 userid , productserialcode , SUM ( [COUNT] ) AS cnt FROM dbo . DM_RW_UserItemsInfo GROUP BY userid , ProductSerialCode
Sqlserver 2005 PIVOT 来进行行列转换，方便很，看了很多往篇文章，这篇是最易懂的
SQL SERVER行转列应用小结
Download details: SQL Server 2005 Samples and Sample Databases
SQL Server 2-D Matrix Builder
Microsoft SQL Server Product Samples: Database - Release: SQL Server 2005 SP2a
查看更多关于tsql使用小记20100127的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did44618