T-SQL关键字集锦


经常有人调试程序时,碰到一些关键字使用错误的提示。
下面这此词都是T-SQL语句中的关键字,在你写SQL语句,存储过程,触发器或字段命名等时要避免使用这些词。
[TR]
ADDEXITPRIMARY
ALLFETCHPRINT
ALTERFILEPRIVILEGES
ANDFILLFACTORPROC
ANYFLOPPYPROCEDURE
ASFORPROCESSEXIT
ASCFOREIGNPUBLIC
AUTHORIZATIONFREETEXTRAISERROR
AVGFREETEXTTABLEREAD
BACKUPFROMREADTEXT
BEGINFULLRECONFIGURE
BETWEENGOTOREFERENCES
BREAKGRANTREPEATABLE
BROWSEGROUPREPLICATION
BULKHAVINGRESTORE
BYHOLDLOCKRESTRICT
CASCADEIDENTITYRETURN
CASEIDENTITY_INSERTREVOKE
CHECKIDENTITYCOLRIGHT
CHECKPOINTIFROLLBACK
CLOSEINROWCOUNT
CLUSTEREDINDEXROWGUIDCOL
COALESCEINNERRULE
COLUMNINSERTSAVE
COMMITINTERSECTSCHEMA
COMMITTEDINTOSELECT
COMPUTEISSERIALIZABLE
CONFIRMISOLATIONSESSION_USER
CONSTRAINTJOINSET
CONTAINSKEYSETUSER
CONTAINSTABLEKILLSHUTDOWN
CONTINUELEFTSOME
CONTROLROWLEVELSTATISTICS
CONVERTLIKESUM
COUNTLINENOSYSTEM_USER
CREATELOADTABLE
CROSSMAXTAPE
CURRENTMINTEMP
CURRENT_DATEMIRROREXITTEMPORARY
CURRENT_TIMENATIONALTEXTSIZE
CURRENT_TIMESTAMPNOCHECKTHEN
CURRENT_USERNONCLUSTEREDTO
CURSORNOTTOP
DATABASENULLTRAN
DBCCNULLIFTRANSACTION
DEALLOCATEOFTRIGGER
DECLAREOFFTRUNCATE
DEFAULTOFFSETSTSEQUAL
DELETEONUNCOMMITTED
DENYONCEUNION
DESCONLYUNIQUE
DISKOPENUPDATE
DISTINCTOPENDATASOURCEUPDATETEXT
DISTRIBUTEDOPENQUERYUSE
DOUBLEOPENROWSETUSER
DROPOPTIONVALUES
DUMMYORVARYING
DUMPORDERVIEW
ELSEOUTERWAITFOR
ENDOVERWHEN
ERRLVLPERCENTWHERE
ERROREXITPERMWHILE
ESCAPEPERMANENTWITH
EXCEPTPIPEWORK
EXECPLANWRITETEXT
EXECUTEPRECISION
EXISTSPREPARE
Copyright © 2008 qcode.org All Rights Reserved 编程开发 由朝夕网络维护