Transact-SQL Reference
New and Enhanced Features in Transact-SQL
Transact-SQL in Microsoft® SQL Server™ 2000 provides new and enhanced statements, stored procedures, functions, data types, DBCC statements, and information schema views.
Data Types
| New data types | |
| bigint | table |
| sql_variant | |
Database Console Commands (DBCC)
| New commands | |
| DBCC CHECKCONSTRAINTS | DBCC DROPCLEANBUFFERS |
| DBCC CLEANTABLE | DBCC FREEPROCCACHE |
| DBCC CONCURRENCYVIOLATION | DBCC INDEXDEFRAG |
| Enhanced commands | |
| DBCC CHECKALLOC | DBCC CHECKFILEGROUP |
| DBCC CHECKDB | DBCC SHOWCONTIG |
| DBCC CHECKTABLE | |
Functions
Information Schema Views
| New information schema views | |
| PARAMETERS | ROUTINE_COLUMNS |
| ROUTINES | |
Replication Stored Procedures
Reserved Keywords
COLLATE, FUNCTION, and OPENXML are reserved keywords in SQL Server 2000.
The following words have been unreserved.
| AVG | COMMITTED |
| CONFIRM | CONTROLROW |
| COUNT | ERROREXIT |
| FLOPPY | ISOLATION |
| LEVEL | MAX |
| MIN | MIRROREXIT |
| ONCE | ONLY |
| PERM | PERMANENT |
| PIPE | PREPARE |
| PRIVILEGES | REPEATABLE |
| SERIALIZABLE | SUM |
| TAPE | TEMP |
| TEMPORARY | UNCOMMITTED |
| WORK |
Statements
| New statements | |
| ALTER FUNCTION | DROP FUNCTION |
| CREATE FUNCTION | |
| Enhanced statements | |
| ALTER DATABASE | CREATE TABLE |
| ALTER TABLE | CREATE TRIGGER |
| BACKUP | INDEXPROPERTY |
| COLUMNPROPERTY | OBJECTPROPERTY |
| CREATE INDEX | RESTORE |
| CREATE STATISTICS | |
System Stored Procedures
| Enhanced system stored procedures | |
|---|---|
| sp_helptrigger | sp_serveroption |
| sp_tableoption | sp_who |