至高吴上(Alfa.wu)

摘要： 特别注意的是: OVER() 在, sql2000中不能用.SQL Server 2005: Using OVER() with Aggregate FunctionsBy Jeff Smith on 21 May 2007 | 4 Comments | Tags: SELECT, Transact-SQL, FunctionsOne of new features in SQL 2005 that I haven't seen much talk about is that you can now add aggregate functions to any SELECT (even 阅读全文

摘要： IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #tcreate table #t ( test int)GOinsert into #t(test) select 100 as testGO 100 select * from #t 阅读全文