VicAnt的专栏

考虑如下表：sutdent： 姓名班级张三一班李四二班score： 姓名科目分数张三语文80张三数学90李四数学100如下语句：select a.[姓名]       ,a.[班级]       ,b.[科目]       ,b.[分数]from student a 

找出在T1有，T表没有的记录。SELECT * FROM T1 WHERE CHECKSUM(*)             NOT IN (SELECT CHECKSUM(*) FROM T)

SQL Server 2005引入了ROW_NUMBER()函数。通过该函数，可以在记录集中方便的增加行号。 以下为在MSDN的解释： ROW_NUMBER (Transact-SQL) Updated: 17 July 2006 Returns the sequential number of a row within a partition of a result set, star

One of new features in SQL 2005 that I havent seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for eac