SQL-92

Explicit join operations

Using multiple tables in a query

ROW_NUMBER function

Ranking functions

Transact-SQL string and datetime functions

Prepare for the second stage of testing

RANK() and DENSE_RANK() functions

Ranking functions

Prepare for the second stage of testing

Book

About implicit conversion of SQL Server data types

Typical problems