SQL 2000 / SQL 2005/ SQL 2008 / SQL 2012

SQL SERVER 2000

Only Maximum of 65,535 databases

No XML data type

No Exception Handling

We cannot Encrypt the DataBase


SQL SERVER 2005

XML Data Type is There

Exception Handling Is There

Varchar(max) and VarBinary(max)

We can Encrypt the DataBase


SQL SERVER 2008

Merge is included

Common Table Expression

Four dateTime Data Types Introduced


SQL SERVER 2012

Pagination 
Sequence Object
Using THROW Statement


CHOOSE (Transact-SQL)
IIF (Transact-SQL)

PARSE (Transact-SQL)
TRY_PARSE (Transact-SQL)
TRY_CONVERT (Transact-SQL)
Date and time Functions

DATEFROMPARTS Function
TIMEFROMPARTS Function
DATETIMEFROMPARTS Function
EMONTH Function .. and so on
String Functions

FORMAT (Transact-SQL)
CONCAT (Transact-SQL)
Analytic Functions

First_Value Function
Last_Value Function