T-SQL关键字集锦
来源:岁月联盟
时间:2003-07-10
下面这此词都是T-SQL语句中的关键字,在你写SQL语句,存储过程,触发器或字段命名等时要避免使用这些词。
ADDEXITPRIMARYALLFETCHPRINTALTERFILEPRIVILEGESANDFILLFACTORPROCANYFLOPPYPROCEDUREASFORPROCESSEXITASCFOREIGNPUBLICAUTHORIZATIONFREETEXTRAISERRORAVGFREETEXTTABLEREADBACKUPFROMREADTEXTBEGINFULLRECONFIGUREBETWEENGOTOREFERENCESBREAKGRANTREPEATABLEBROWSEGROUPREPLICATIONBULKHAVINGRESTOREBYHOLDLOCKRESTRICTCASCADEIDENTITYRETURNCASEIDENTITY_INSERTREVOKECHECKIDENTITYCOLRIGHTCHECKPOINTIFROLLBACKCLOSEINROWCOUNTCLUSTEREDINDEXROWGUIDCOLCOALESCEINNERRULECOLUMNINSERTSAVECOMMITINTERSECTSCHEMACOMMITTEDINTOSELECTCOMPUTEISSERIALIZABLECONFIRMISOLATIONSESSION_USERCONSTRAINTJOINSETCONTAINSKEYSETUSERCONTAINSTABLEKILLSHUTDOWNCONTINUELEFTSOMECONTROLROWLEVELSTATISTICSCONVERTLIKESUMCOUNTLINENOSYSTEM_USERCREATELOADTABLECROSSMAXTAPECURRENTMINTEMPCURRENT_DATEMIRROREXITTEMPORARYCURRENT_TIMENATIONALTEXTSIZECURRENT_TIMESTAMPNOCHECKTHENCURRENT_USERNONCLUSTEREDTOCURSORNOTTOPDATABASENULLTRANDBCCNULLIFTRANSACTIONDEALLOCATEOFTRIGGERDECLAREOFFTRUNCATEDEFAULTOFFSETSTSEQUALDELETEONUNCOMMITTEDDENYONCEUNIONDESCONLYUNIQUEDISKOPENUPDATEDISTINCTOPENDATASOURCEUPDATETEXTDISTRIBUTEDOPENQUERYUSEDOUBLEOPENROWSETUSERDROPOPTIONVALUESDUMMYORVARYINGDUMPORDERVIEWELSEOUTERWAITFORENDOVERWHENERRLVLPERCENTWHEREERROREXITPERMWHILEESCAPEPERMANENTWITHEXCEPTPIPEWORKEXECPLANWRITETEXTEXECUTEPRECISION [TR]EXISTSPREPARE