T-SQL关键字集锦

下面这些词都是T-SQL语句中的关键字，在你写SQL语句，存储过程，触发器或字段命名等时要避免使用这些词。

ADD EXIT PRIMARY

ALL FETCH PRINT

alter FILE PRIVILEGES

AND FILLFACTOR PROC

ANY FLOPPY PROCEDURE

AS FOR PROCESSEXIT

ASC FOREIGN PUBLIC

AUTHORIZATION FREETEXT RAISERROR

AVG FREETEXTTABLE READ

BACKUP FROM READTEXT

BEGIN FULL RECONFIGURE

BETWEEN GOTO REFERENCES

BREAK GRANT REPEATABLE

BROWSE GROUP REPLICATION

BULK HAVING RESTORE

BY HOLDLOCK RESTRICT

CASCADE IDENTITY RETURN

CASE IDENTITY_insert REVOKE

CHECK IDENTITYCOL RIGHT

CHECKPOINT IF ROLLBACK

CLOSE IN ROWcount

CLUSTERED INDEX ROWGUIDCOL

COALESCE INNER RULE

COLUMN insert SAVE

COMMIT INTERSECT SCHEMA

COMMITTED INTO select

COMPUTE IS SERIALIZABLE

CONFIRM ISOLATION SESSION_USER

CONSTRAINT join SET

CONTAINS KEY SETUSER

CONTAINSTABLE KILL SHUTDOWN

CONTINUE LEFT SOME

CONTROLROW LEVEL STATISTICS

CONVERT like SUM

count LINENO SYSTEM_USER

create LOAD TABLE

CROSS MAX TAPE

CURRENT MIN TEMP

CURRENT_DATE MIRROREXIT TEMPORARY

CURRENT_TIME NATIONAL TEXTSIZE

CURRENT_TIMESTAMP NOCHECK THEN

CURRENT_USER NONCLUSTERED TO

CURSOR NOT TOP

DATABASE NULL TRAN

DBCC NULLIF TRANSACTION

DEALLOCATE OF TRIGGER

DECLARE OFF truncate

DEFAULT OFFSETS TSEQUAL

delete ON UNCOMMITTED

DENY ONCE union

DESC ONLY UNIQUE

DISK OPEN update

DISTINCT OPENDATASOURCE updateTEXT

DISTRIBUTED OPENQUERY USE

DOUBLE OPENROWSET USER

drop OPTION VALUES

DUMMY OR VARYING

DUMP ORDER VIEW

ELSE OUTER WAITFOR

END OVER WHEN

ERRLVL PERCENT where

ERROREXIT PERM WHILE

ESCAPE PERMANENT WITH

EXCEPT PIPE WORK

exec PLAN WRITETEXT

execute PRECISION

exists PREPARE