T-SQL关键字集锦

来源:岁月联盟 编辑:zhuzhu 时间:2003-07-10
经常有人调试程序时,碰到一些关键字使用错误的提示。
下面这此词都是T-SQL语句中的关键字,在你写SQL语句,存储过程,触发器或字段命名等时要避免使用这些词。
ADDEXITPRIMARYALLFETCHPRINTALTERFILEPRIVILEGESANDFILLFACTORPROCANYFLOPPYPROCEDUREASFORPROCESSEXITASCFOREIGNPUBLICAUTHORIZATIONFREETEXTRAISERRORAVGFREETEXTTABLEREADBACKUPFROMREADTEXTBEGINFULLRECONFIGUREBETWEENGOTOREFERENCESBREAKGRANTREPEATABLEBROWSEGROUPREPLICATIONBULKHAVINGRESTOREBYHOLDLOCKRESTRICTCASCADEIDENTITYRETURNCASEIDENTITY_INSERTREVOKECHECKIDENTITYCOLRIGHTCHECKPOINTIFROLLBACKCLOSEINROWCOUNTCLUSTEREDINDEXROWGUIDCOLCOALESCEINNERRULECOLUMNINSERTSAVECOMMITINTERSECTSCHEMACOMMITTEDINTOSELECTCOMPUTEISSERIALIZABLECONFIRMISOLATIONSESSION_USERCONSTRAINTJOINSETCONTAINSKEYSETUSERCONTAINSTABLEKILLSHUTDOWNCONTINUELEFTSOMECONTROLROWLEVELSTATISTICSCONVERTLIKESUMCOUNTLINENOSYSTEM_USERCREATELOADTABLECROSSMAXTAPECURRENTMINTEMPCURRENT_DATEMIRROREXITTEMPORARYCURRENT_TIMENATIONALTEXTSIZECURRENT_TIMESTAMPNOCHECKTHENCURRENT_USERNONCLUSTEREDTOCURSORNOTTOPDATABASENULLTRANDBCCNULLIFTRANSACTIONDEALLOCATEOFTRIGGERDECLAREOFFTRUNCATEDEFAULTOFFSETSTSEQUALDELETEONUNCOMMITTEDDENYONCEUNIONDESCONLYUNIQUEDISKOPENUPDATEDISTINCTOPENDATASOURCEUPDATETEXTDISTRIBUTEDOPENQUERYUSEDOUBLEOPENROWSETUSERDROPOPTIONVALUESDUMMYORVARYINGDUMPORDERVIEWELSEOUTERWAITFORENDOVERWHENERRLVLPERCENTWHEREERROREXITPERMWHILEESCAPEPERMANENTWITHEXCEPTPIPEWORKEXECPLANWRITETEXTEXECUTEPRECISION [TR]EXISTSPREPARE