SQL Server 保留關(guān)鍵字Microsoft SQL Server 2000 使用保留關(guān)鍵字定義、操作和訪問(wèn)數(shù)據(jù)庫(kù)。保留關(guān)鍵字是 SQL Server 使用的 Transact-SQL 語(yǔ)言語(yǔ)法的一部分，用于分析和理解 Transact-SQL 語(yǔ)句和批處理。盡管在 Transact-SQL 腳本中，使用 SQL Server 保留關(guān)鍵字作為標(biāo)識(shí)符和對(duì)象名在語(yǔ)法上是可行的，但規(guī)定只能使用分隔標(biāo)識(shí)符。下表列出了 SQL Server 的保留關(guān)鍵字。ADDEXCEPTPERCENTALLEXECPLANALTEREXECUTEPRECISIONANDEXISTSPRIMARYANYEXITPRINTASFETCHPROCASCFILEPROCEDUREAUTHORIZATIONFILLFACTORPUBLICBACKUPFORRAISERRORBEGINFOREIGNREADBETWEENFREETEXTREADTEXTBREAKFREETEXTTABLERECONFIGUREBROWSEFROMREFERENCESBULKFULLREPLICATIONBYFUNCTIONRESTORECASCADEGOTORESTRICTCASEGRANTRETURNCHECKGROUPREVOKECHECKPOINTHAVINGRIGHTCLOSEHOLDLOCKROLLBACKCLUSTEREDIDENTITYROWCOUNTCOALESCEIDENTITY_INSERTROWGUIDCOLCOLLATEIDENTITYCOLRULECOLUMNIFSAVECOMMITINSCHEMACOMPUTEINDEXSELECTCONSTRAINTINNERSESSION_USERCONTAINSINSERTSETCONTAINSTABLEINTERSECTSETUSERCONTINUEINTOSHUTDOWNCONVERTISSOMECREATEJOINSTATISTICSCROSSKEYSYSTEM_USERCURRENTKILLTABLECURRENT_DATELEFTTEXTSIZECURRENT_TIMELIKETHENCURRENT_TIMESTAMPLINENOTOCURRENT_USERLOADTOPCURSORNATIONALTRANDATABASENOCHECKTRANSACTIONDBCCNONCLUSTEREDTRIGGERDEALLOCATENOTTRUNCATEDECLARENULLTSEQUALDEFAULTNULLIFUNIONDELETEOFUNIQUEDENYOFFUPDATEDESCOFFSETSUPDATETEXTDISKONUSEDISTINCTOPENUSERDISTRIBUTEDOPENDATASOURCEVALUESDOUBLEOPENQUERYVARYINGDROPOPENROWSETVIEWDUMMYOPENXMLWAITFORDUMPOPTIONWHENELSEORWHEREENDORDERWHILEERRLVLOUTERWITHESCAPEOVERWRITETEXT

另外，SQL-92 標(biāo)準(zhǔn)還定義了保留關(guān)鍵字列表。不要使用 SQL-92 保留關(guān)鍵字作為對(duì)象名和標(biāo)識(shí)符。ODBC 保留關(guān)鍵字列表（如下所示）與 SQL-92 保留關(guān)鍵字列表相同。說(shuō)明??SQL-92 保留關(guān)鍵字列表有時(shí)可能比 SQL Server 限制更多，有時(shí)則限制更少。例如，SQL-92 保留關(guān)鍵字列表包含 INT，而 SQL Server 不需要將其區(qū)分為保留關(guān)鍵字。Transact-SQL 保留關(guān)鍵字可用作數(shù)據(jù)庫(kù)或數(shù)據(jù)庫(kù)對(duì)象（如表、列、視圖等）的標(biāo)識(shí)符或名稱。使用被引用的標(biāo)識(shí)符或分隔標(biāo)識(shí)符。對(duì)將保留關(guān)鍵字用作變量和存儲(chǔ)過(guò)程參數(shù)的名稱沒(méi)有限制。ODBC 保留關(guān)鍵字保留了下列關(guān)鍵字用于 ODBC 函數(shù)調(diào)用。這些關(guān)鍵字根本不約束 SQL 語(yǔ)法；然而，為確保與支持核心 SQL 語(yǔ)法的驅(qū)動(dòng)程序兼容，應(yīng)用程序應(yīng)避免使用這些關(guān)鍵字。下面是當(dāng)前的 ODBC 保留關(guān)鍵字列表。有關(guān)更多信息，請(qǐng)參見《Microsoft ODBC 3.0 程序員參考》，第 2 卷，附錄 C。ABSOLUTEEXECOVERLAPSACTIONEXECUTEPADADAEXISTSPARTIALADDEXTERNALPASCALALLEXTRACTPOSITIONALLOCATEFALSEPRECISIONALTERFETCHPREPAREANDFIRSTPRESERVEANYFLOATPRIMARYAREFORPRIORASFOREIGNPRIVILEGESASCFORTRANPROCEDUREASSERTIONFOUNDPUBLICATFROMREADAUTHORIZATIONFULLREALAVGGETREFERENCESBEGINGLOBALRELATIVEBETWEENGORESTRICTBITGOTOREVOKEBIT_LENGTHGRANTRIGHTBOTHGROUPROLLBACKBYHAVINGROWSCASCADEHOURSCHEMACASCADEDIDENTITYSCROLLCASEIMMEDIATESECONDCASTINSECTIONCATALOGINCLUDESELECTCHARINDEXSESSIONCHAR_LENGTHINDICATORSESSION_USERCHARACTERINITIALLYSETCHARACTER_LENGTHINNERSIZECHECKINPUTSMALLINTCLOSEINSENSITIVESOMECOALESCEINSERTSPACECOLLATEINTSQLCOLLATIONINTEGERSQLCACOLUMNINTERSECTSQLCODECOMMITINTERVALSQLERRORCONNECTINTOSQLSTATECONNECTIONISSQLWARNINGCONSTRAINTISOLATIONSUBSTRINGCONSTRAINTSJOINSUMCONTINUEKEYSYSTEM_USERCONVERTLANGUAGETABLECORRESPONDINGLASTTEMPORARYCOUNTLEADINGTHENCREATELEFTTIMECROSSLEVELTIMESTAMPCURRENTLIKETIMEZONE_HOURCURRENT_DATELOCALTIMEZONE_MINUTECURRENT_TIMELOWERTOCURRENT_TIMESTAMPMATCHTRAILINGCURRENT_USERMAXTRANSACTIONCURSORMINTRANSLATEDATEMINUTETRANSLATIONDAYMODULETRIMDEALLOCATEMONTHTRUEDECNAMESUNIONDECIMALNATIONALUNIQUEDECLARENATURALUNKNOWNDEFAULTNCHARUPDATEDEFERRABLENEXTUPPERDEFERREDNOUSAGEDELETENONEUSERDESCNOTUSINGDESCRIBENULLVALUEDESCRIPTORNULLIFVALUESDIAGNOSTICSNUMERICVARCHARDISCONNECTOCTET_LENGTHVARYINGDISTINCTOFVIEWDOMAINONWHENDOUBLEONLYWHENEVERDROPOPENWHEREELSEOPTIONWITHENDORWORKEND-EXECORDERWRITEESCAPEOUTERYEAREXCEPTOUTPUTZONEEXCEPTION