Bookmark : It Depends

A brilliant SQL Server Central article published this morning, comparing MAX() , TOP(1) and ROWNUMBER()  as methods for getting ID values back from a table.


http://www.sqlservercentral.com/articles/T-SQL/69481/