The following features added in SQL Server 2000 from its previous version:
New data types were added (BIGINT, SQL_VARIANT, TABLE)
Instead of and for Triggers were introduced as advancement to the DDL.
Cascading referential integrity.
XML support
User defined functions and partition views.
In...
