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


« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3