T-SQL关键字集锦

日期: 2008-06-18 来源:TechTarget中国

  下面这些词都是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
  &#101xec PLAN WRITETEXT
  &#101xecute PRECISION
  exists PREPARE

我们一直都在努力坚持原创.......请不要一声不吭,就悄悄拿走。

我原创,你原创,我们的内容世界才会更加精彩!

【所有原创内容版权均属TechTarget,欢迎大家转发分享。但未经授权,严禁任何媒体(平面媒体、网络媒体、自媒体等)以及微信公众号复制、转载、摘编或以其他方式进行使用。】

微信公众号

TechTarget微信公众号二维码

TechTarget

官方微博

TechTarget中国官方微博二维码

TechTarget中国

电子邮件地址不会被公开。 必填项已用*标注

敬请读者发表评论,本站保留删除与本文无关和不雅评论的权力。

相关推荐