T-SQL关键字集锦

类别:Asp 点击:0 评论:0 推荐:
下面这此词都是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

本文地址:http://com.8s8s.com/it/it8054.htm