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

转载于:https://www.cnblogs.com/dfsxh/archive/2008/11/27/1342104.html