Monday, January 26, 2009

Top and Order By Combination - SQL Server knowledge center

"View object is a table expression (in sql server 2005 and above); and if you specify ORDER BY clause, the result would not be a table expression but ANSI SQL cursor statement. SQL Server 2005 and later version put View objects as pure table expression so that they will ignore TOP…ORDER BY combination in View."

Top and Order By Combination - SQL Server knowledge center

Post a Comment