SQL SERVER – 2005 TOP Improvements/Enhancements | Journey to SQL Authority with Pinal Dave

SQL Server 2005 introduces two enhancements to the TOP clause. 1) User can specify an expression as an input to the TOP keyword. 2) User can use TOP in modification statements (INSERT, UPDATE, and DELETE). Explanation : User can specify an expression as an input to the TOP keyword. In SQL SERVER 2000 usage of… Continue Reading...

Source: SQL SERVER – 2005 TOP Improvements/Enhancements | Journey to SQL Authority with Pinal Dave