Sql server 关键字 'User' 附近有语法错误

     下面这此词都是T-SQL语句中的关键字，在写SQL语句，存储过程，触发器或字段命名等时要避免使用这些词。

ADDEXITPRIMARYALLFETCHPRINTALTERFILEPRIVILEGESANDFILLFACTORPROCANYFLOPPYPROCEDUREASFORPROCESSEXITASCFOREIGNPUBLICAUTHORIZATIONFREETEXTRAISERRORAVGFREETEXTTABLEREADBACKUPFROMREADTEXTBEGINFULLRECONFIGUREBETWEENGOTOREFERENCESBREAKGRANTREPEATABLEBROWSEGROUPREPLICATIONBULKHAVINGRESTOREBYHOLDLOCKRESTRICTCASCADEIDENTITYRETURNCASEIDENTITY_INSERTREVOKECHECKIDENTITYCOLRIGHTCHECKPOINTIFROLLBACKCLOSEINROWCOUNTCLUSTEREDINDEXROWGUIDCOLCOALESCEINNERRULECOLUMNINSERTSAVECOMMITINTERSECTSCHEMACOMMITTEDINTOSELECTCOMPUTEISSERIALIZABLECONFIRMISOLATIONSESSION_USERCONSTRAINTJOINSETCONTAINSKEYSETUSERCONTAINSTABLEKILLSHUTDOWNCONTINUELEFTSOMECONTROLROWLEVELSTATISTICSCONVERTLIKESUMCOUNTLINENOSYSTEM_USERCREATELOADTABLECROSSMAXTAPECURRENTMINTEMPCURRENT_DATEMIRROREXITTEMPORARYCURRENT_TIMENATIONALTEXTSIZECURRENT_TIMESTAMPNOCHECKTHENCURRENT_USERNONCLUSTEREDTOCURSORNOTTOPDATABASENULLTRANDBCCNULLIFTRANSACTIONDEALLOCATEOFTRIGGERDECLAREOFFTRUNCATEDEFAULTOFFSETSTSEQUALDELETEONUNCOMMITTEDDENYONCEUNIONDESCONLYUNIQUEDISKOPENUPDATEDISTINCTOPENDATASOURCEUPDATETEXTDISTRIBUTEDOPENQUERYUSEDOUBLEOPENROWSETUSERDROPOPTIONVALUESDUMMYORVARYINGDUMPORDERVIEWELSEOUTERWAITFORENDOVERWHENERRLVLPERCENTWHEREERROREXITPERMWHILEESCAPEPERMANENTWITHEXCEPTPIPEWORKEXECPLANWRITETEXTEXECUTEPRECISION​EXISTSPREPARE

但发果不经意用到一些关键字 尤其是像user、 work 等等，所以在碰到上面的 错误提示信息后 就要联想到这些，不妨试着 添加 [ ]，问题就迎刃而解了。 如果担心出现这类问题 可以提前将需查询的所有表名都添加 [ ]。