Microsoft SQL Server 2000 Transact-SQL和技术参考手册 (2008 年度畅销榜NO.41406 )

Transact-SQL对使用Microsoft SQL Server非常重要。与SQL Server通讯的所有应用程序都通过向服务器发送Transact-SQL语句来进行通讯，而与应用程序的用户界面无关。本书即介绍了Transact-SQL中的新特性和增强的功能、Transact-SQL语法规则，尤其详细介绍了SQL使用中（如管理 SQL Server、创建与维护数据库、访问和更改关系数据库）Transact-SQL语句中的数据类型、特性等，是SQL Server用户的必备参考手册。\r\n

第1章 Transact-SQL概述\r\n\r\n第2章 Transact-SQL语法规则\r\n\r\n第3章 Transact-SQL中的新特性和增强的功能\r\n\r\n第4章 Transact-SQL详解\r\n\r\n+（加）\r\n+（正）\r\n+（字符串串联）\r\n-（负）\r\n-（减）\r\n*（乘）\r\n/（除）\r\n%（模）\r\n%（通配符——需匹配的字符）\r\n&（按位AND）\r\n|（按位OR）\r\n^（按位互斥OR）\r\n~（按位NOT）\r\n=（等于）\r\n&gt（大于）\r\n&lt（小于）\r\n&gt=（大于或等于）\r\n&lt=（小于或等于）\r\n&lt&gt（不等于）\r\n！&lt（不小于）\r\n！=（不等于）\r\n！&gt（不大于）\r\n--（注释）\r\n/*...*/（注释）\r\n[]（通配符-需匹配的字符）\r\n[^]（通配符字符-无需匹配的字符）\r\n-（通配符-匹配一个字符）\r\n@@CONNECTIONS\r\n@@CPU_BUSY\r\n@@CURSOR_ROWS\r\n@@DATEFIRST\r\n@@DBTS\r\n@@ERROR\r\n@@FETCH_STATUS\r\n@@IDENTITY\r\n@@IDLE\r\n@@IO_BUSY\r\n@@LANGID\r\n@@LANGUAGE\r\n@@LOCK_TIMEOUT\r\n@@MAX_CONNECTIONS\r\n@@MAX_PRECISION\r\n@@NESTLEVEL\r\n@@OPTIONS\r\n@@PACK_RECEIVED\r\n@@PACK_SENT\r\n@@PACKET_ERRORS\r\n@@PROCID\r\n@@REMSERVER\r\n@@ROWCOUNT\r\n@@SERVERNAME\r\n@@SERVICENAME\r\n@@SPID\r\n@@TEXTSIZE\r\n@@TIMETICKS\r\n@@TOTAL_ERRORS\r\n@@TOTAL_READ\r\n@@TOTAL_WRITE\r\n@@TRANCOUNT\r\n@@VERSION\r\nABS\r\nACOS\r\nALL\r\nALTER DATABASE\r\nALTER FUNCTION\r\nALTER PROCEDURE\r\nALTER TABLE\r\nALTER TRIGGER\r\nALTER VIEW\r\nAND\r\nANY\r\nAPP_NAME\r\nASCII\r\nASIN\r\nATAN\r\nATN2\r\nAVG\r\nBACKUP\r\nBEGIN...END\r\nBEGIN DISTRIBUTED TRANSACTION\r\nBEGIN TRANSACTION\r\nBETWEEN\r\nbinary和varbinary\r\nBINARY_CHECKSUM\r\nbit\r\nBREAK\r\nBULKINSERT\r\nCASE\r\nCAST和CONVERT\r\nCEILING\r\nchar和varchar\r\nCHAR\r\nCHARINDEX\r\nCHECKPOINT\r\nCHECKSUM\r\nCHECKSUM_AGG\r\nCLOSE\r\nCOALESCE\r\nCOLLATE\r\nWindows排序规则名称\r\nSQL排序规则名称\r\nCOLLATIONPROPERTY\r\nCOL_LENGTH\r\nCOL_NAME\r\nCOLUMNPROPERTY\r\nCOMMIT TRANSACTION\r\nCOMMIT WORK\r\n常量\r\nCONTAINS\r\nCONTAINSTABLE\r\nCONTINUE\r\n控制流语言\r\nCOS\r\nCOT \r\nCOUNT\r\nCOUNT_BIG\r\nCREATE DATABASE\r\nCREATE DEFAULT\r\nCREATE FUNCTION\r\nCREATE INDEX\r\nCREATE PROCEDURE\r\nCREATE RULE\r\nCREATE SCHEMA\r\nCREATE STATISTICS\r\nCREATE TABLE\r\nCREATE TRIGGER\r\nCREATE VIEW\r\nCURRENT_TIMESTAMP\r\nCURRENT_USER\r\ncursor\r\nCURSOR_STATUS\r\n游标\r\nDATABASEPROPERTY\r\nDATABASEPROPERTYEX\r\n数据类型\r\n数据类型的优先顺序\r\n排序规则的优先顺序\r\n精度、小数位数和长度\r\n数据类型同义词\r\nDATALENGTH\r\nDATEADD\r\nDATEDIFF\r\nDATENAME\r\nDATEPART\r\ndatetime和smalldatetime\r\nDAY\r\nDB_ID\r\nDB_NAME\r\nDBCC\r\nDBCC CHECKALLOC\r\nDBCC CHECKCATALOG\r\nDBCC CHECKCONSTRAINTS\r\nDBCC CHECKDB\r\nDBCC CHECKFILEGROUP\r\nDBCC CHECKIDENT\r\nDBCC CHECKTABLE\r\nDBCC CLEANTABLE\r\nDBCC CONCURRENCYVIOLATION\r\nDBCC DBREPAIR\r\nDBCC DBREINDEX\r\nDBCC dllname（FREE）\r\nDBCC DROPCLEANBUFFERS\r\nDBCC FREEPROCCACHE\r\nDBCC HELP\r\nDBCC INDEXDEFRAG\r\nDBCC INPUTBUFFER\r\nDBCC NEWALLOC\r\nDBCC OPENTRAN\r\nDBCC OUTPUTBUFFER\r\nDBCC PINTABLE\r\nDBCC PROCCACHE\r\nDBCC ROWLOCK\r\nDBCC SHOWCONTIG\r\nDBCC SHOW_STATISTICS\r\nDBCC SHRINKDATABASE\r\nDBCC SHRINKFILE\r\nDBCC SQLPERF\r\nDBCC TRACEOFF\r\nDBCC TRACEON\r\nDBCC TRACESTATUS\r\nDBCC UNPINTABLE\r\nDBCC UPDATEUSAGE\r\nDBCC USEROPTIONS\r\nDEALLOCATE\r\ndecimal和numeric\r\nDECLARE@local_variable\r\nDECLARE CURSOR\r\nDEGREES\r\nDELETE\r\nDENY\r\nDIFFERENCE\r\nDROP DATABASE\r\nDROP DEFAULT\r\nDROP FUNCTION\r\nDROP INDEX\r\nDROP PROCEDURE\r\nDROP RULE\r\nDROP STATISTICS\r\nDROP TABLE\r\nDROP TRIGGER\r\nDROP VIEW\r\nDUMP\r\nELSE（IF...ELSE）\r\nEND（BEGIN...END）\r\nEXECUTE\r\nEXISTS\r\nEXP\r\n表达式\r\nFETCH\r\nFILE_ID\r\nFILE_NAME\r\nFILEGROUP_ID\r\nFILEGROUP_NAME\r\nFILEGROUPPROPERTY\r\nFILEPROPERTY\r\nfloat和real\r\nFLOOR\r\nfn_helpcollations\r\nfn_listextendedproperty\r\nfn_servershareddrives\r\nfn_trace_geteventinfo\r\nfn_trace_getfilterinfo\r\nfn_trace_getinfo\r\nfn_trace_gettable\r\nfn_virtualfilestats\r\nfn_virtualservernodes\r\nFORMATMESSAGE\r\nFREETEXTTABLE\r\nFROM\r\nFULLTEXTCATALOGPROPERTY\r\nFULLTEXTSERVICEPROPERTY\r\n函数\r\n聚合函数\r\n配置函数\r\n游标函数\r\n日期和时间函数\r\n数学函数\r\n元数据函数\r\n行集函数\r\n安全函数\r\n字符串函数\r\n系统函数\r\n系统统计函数\r\n文本和图像函数\r\nGETANSINULL\r\nGETDATE\r\nGETUTCDATE\r\nGO\r\nGOTO\r\nGRANT\r\nGROUP BY\r\nGROUPING\r\nHAS_DBACCESS\r\nHAVING\r\nHOST_ID\r\nHOST_NAME\r\nIDENT_CURRENT\r\nIDENT_INCR\r\nIDENT_SEED\r\nIDENTITY（属性）\r\nIDENTITY（函数）\r\nIF...ELSE\r\nimage\r\nIN\r\nINDEXKEY_PROPERTY\r\nINDEXPROPERTY\r\nINDEX_COL\r\n信息架构视图\r\nCHECK_CONSTRAINTS\r\nCOLUMN_DOMAIN_USAGE\r\nCOLUMN_PRIVILEGES\r\nCOLUMNS\r\nCONSTRAINT_COLUMN_USAGE\r\nCONSTRAINT_TABLE_USAGE\r\nDOMAIN_CONSTRAINTS\r\nDOMAINS\r\nKEY_COLUMN_USAGE\r\nPARAMETERS\r\nREFERENTIAL_CONSTRAINTS\r\nROUTINES\r\nROUTINE_COLUMNS\r\nSCHEMATA\r\nTABLE_CONSTRAINTS\r\nTABLE_PRIVILEGES\r\nTABLES\r\nVIEW_COLUMN_USAGE\r\nVIEW_TABLE_USAGE\r\nVIEWS\r\nINSERT\r\nint、bigint、smallint和tinyint\r\nIS_MEMBER\r\nIS_SRVROLEMEMBER\r\nISDATE\r\nIS[NOT]NULL\r\nISNULL\r\nISNUMERIC\r\nKILL\r\nLEFT\r\nLEN\r\nLIKE\r\nLOAD\r\nLOG\r\nLOG10\r\nLOWER\r\nLTRIM\r\nMAX\r\nMIN\r\nmoney和smallmoney\r\nMONTH\r\nNCHAR\r\nnchar和nvarchar\r\nNEWID\r\nNorthwind示例数据库\r\nCategories\r\nCustomers\r\nCustomerCustomerDemo\r\nCustomerDemographics\r\nEmployees\r\nEmployeeTerritories\r\nOrder Details\r\nOrders\r\nProducts\r\nRegion\r\nShippers\r\nSuppliers\r\nTerritories\r\nNOT\r\nntext、text和image\r\nNULLIF\r\nnumeric\r\nOBJECT_ID\r\nOBJECT_NAME\r\nOBJECTPROPERTY\r\nOPEN\r\nOPENDATASOURCE\r\nOPENQUERY\r\nOPENROWSET\r\nOPENXML\r\n运算符\r\nOR\r\nORDER BY\r\nPARSENAME\r\nPATINDEX\r\nPERMISSIONS\r\nPI\r\nPOWER\r\nPredicate\r\nPRINT\r\npubs示例数据库\r\nauthors\r\ndiscounts\r\nemployee\r\njobs\r\npub_info\r\npublishers\r\nroysched\r\nsales\r\nstores\r\ntitleauthor\r\ntitles\r\nQUOTENAME\r\nRADIANS\r\nRAISERROR\r\nRAND\r\nREADTEXT\r\nreal\r\nRECONFIGURE\r\nREPLACE\r\nREPLICATE\r\n保留关键字\r\nRESTORE\r\nRESTORE FILELISTONLY\r\nRESTORE HEADERONLY\r\nRESTORE LABELONLY\r\nRESTORE VERIFYONLY\r\nRETURN\r\nREVERSE\r\nREVOK\r\nRIGHT\r\nROLLBACK TRANSACTION\r\nROLLBACK WORK\r\nROUND\r\nROWCOUNT_BIG\r\nRTRIM\r\nSAVE TRANSACTION\r\nSCOPE_IDENTITY\r\n搜索条件\r\nSELECT@local_variable\r\nSELECT\r\nSELECT示例\r\nSERVERPRO PERTY\r\nSESSION_USER\r\nSESSIONPROPERTY\r\nSET@local_variable\r\nSET\r\nSET ANSI_DEFAULTS\r\nSET ANSI_NULL_DFLT_OFF\r\nSET ANSI_NULL_DFLT_ON\r\nSET ANSI_NULLS\r\nSET ANSI_PADDING\r\nSET ANSI_WARNINGS\r\nSET ARITHABORT\r\nSET ARITHIGNORE\r\nSET CONCAT_NULL_YIELDS_NULL\r\nSET CONTEXT_INFO\r\nSET CURSOR_CLOSE_ON_COMMIT\r\nSET DATEFIRST\r\nSET DATEFORMAT\r\nSET DEADLOCK_PRIORITY\r\nSET DISABLE_DEF_CNST_CHK\r\nSET FIPS_FLAGGER\r\nSET FMTONLY\r\nSET FORCEPLAN\r\nSET IDENTITY_INSERT\r\nSET IMPLICIT_TRANSACTIONS\r\nSET LANGUAGE\r\nSET LOCK_TIMEOUT\r\nSET NOCOUNT\r\nSET NOEXEC\r\nSET NUMERIC_ROUNDABORT\r\nSET OFFSETS\r\nSET PARSEONLY\r\nSET QUERY_GOVERNOR_COST_LIMIT\r\nSET QUOTED_IDENTIFIER\r\nSET REMOTE_PROC_TRANSACTIONS\r\nSET ROWCOUNT\r\nSET SHOWPLAN_ALL\r\nSET SHOWPLAN_TEXT\r\nSET STATISTICS IO\r\nSET STATISTICS PROFILE\r\nSET STATISTICS TIME\r\nSET TEXTSIZE\r\nSET TRANSACTION ISOLATION LEVEL\r\nSET XACT_ABORT\r\nSETUSER\r\nSHUTDOWN\r\nSIGN\r\nSIN\r\nsmalldatetime\r\nsmallint\r\nsmallmoney\r\nSOME|ANY\r\nSOUNDEX\r\nSPACE\r\nsql_variant\r\nSQL_VARIANT_PROPERTY\r\nSQUARE\r\nSQRT\r\nSTATS_DATE \r\n\r\nSTDEV\r\nSTDEVP\r\nSTR\r\nSTUFF\r\nSUBSTRING\r\nSUM\r\nSUSER_ID\r\nSUSER_NAME\r\nSUSER_SID\r\nSUSER_SNAME\r\n系统存储过程\r\n对象层次结构语法\r\nsp_ActiveDirectory_Obj\r\nsp_ActiveDirectory_SCP\r\nsp_add_alert\r\nsp_addalias\r\nsp_addapprole\r\nsp_add_data_file_recover_suspect_db\r\nsp_addextendedproc\r\nsp_addextendedproperty\r\nsp_addgroup\r\nsp_add_category\r\nsp_add_job\r\nsp_add_jobschedule\r\nsp_add_jobserver\r\nsp_add_jobstep\r\nsp_addlinkedserver\r\nsp_addlinkedsrvlogin\r\nsp_add_log_file_recover_suspect_db\r\nsp_addlogin\r\nsp_add_log_shipping_database\r\nsp_add_log_shipping_plan\r\nsp_add_shipping_plan_database\r\nsp_add_log_shipping_primary\r\nsp_add_log_shipping_secondary\r\nsp_add_maintenance_plan\r\nsp_add_maintenance_plan_db\r\nsp_add_maintenance_plan_job\r\nsp_addmessage\r\nsp_add_notification\r\nsp_add_operator\r\nsp_addremotelogin\r\nsp_addrole\r\nsp_addrolemember\r\nsp_addserver\r\nsp_addsrvrolemember\r\nsp_addtask\r\nsp_addtype\r\nsp_add_targetservergroup\r\nsp_addumpdevice\r\nsp_add_targetsvrgrp_member\r\nsp_adduser\r\nsp_altermessage\r\nsp_apply_job_to_targets\r\nsp_approlepassword\r\nsp_attach_db\r\nsp_attach_single_file_db\r\nsp_autostats\r\nsp_bundefault\r\nsp_bindrule\r\nsp_bundsession\r\nsp_can_tlog_be_applied\r\nsp_catalogs\r\nsp_certify_removable\r\nsp_change_monitor_role\r\nsp_change_primary_role\r\nsp_change_secondary_role\r\nsp_changeS_users_login\r\nsp_changedbowner\r\nsp_changegroup\r\nsp_changeobjectowner\r\nsp_column_privileges\r\nsp_column_privileges_ex\r\nsp_columns\r\nsp_columns_ex\r\nsp_configure\r\nsp_create_log_shipping_monitor_account\r\nsp_create_removable\r\nsp_createstats\r\nsp_cursor_list\r\nsp_cycle_errorlog\r\nsp_databases\r\nsp_datatype_info\r\nsp_dbcmptlevel\r\nsp_dbfixedrolepermission\r\nsp_dboption\r\nsp_dbremove\r\nsp_defaultdb\r\nsp_defaultlanguage\r\nsp_define_log_shipping_monitor\r\nsp_delete_alert\r\nsp_delete_backuphistory\r\nsp_delete_category\r\nsp_delete_database_backuphisory\r\nsp_delete_job\r\nsp_delete_jobschedule\r\nsp_delete_jobserver\r\nsp_delete_jobstep\r\nsp_delete_log_shipping_database\r\nsp_delete_log_shipping_monitor_info\r\nsp_delete_log_shipping_plan\r\nsp_delete_log_shipping_plan_database\r\nsp_delete_log_shipping_primary\r\nsp_delete_log_shipping_secondary\r\nsp_delete_maintenance_plan\r\nsp_delete_maintenance_plan_db\r\nsp_delete_maintenance_plan_job\r\nsp_delete_notification\r\nsp_delete_operator\r\nsp_delete_targetserver\r\nsp_delete_targetservergroup\r\nsp_delete_targetsvrgrp_member\r\nsp_denylogin\r\nsp_depends\r\nsp_describe_cursor\r\nsp_describe_cursor_columns\r\nsp_describe_cursor_tables\r\nsp_detach_db\r\nsp_dropalias\r\nsp_dropapprole\r\nsp_dropdevice\r\nsp_dropextendedproc\r\nsp_dropextendedproperty\r\nsp_dropgroup\r\nsp_droplinkedsrvlogin\r\nsp_droplogin\r\nsp_dropmessage\r\nsp_dropremotelogin\r\nsp_droprole\r\nsp_droprolemember\r\nsp_droptask\r\nsp_droptype\r\nsp_dropuser\r\nsp_dropwebtask\r\nsp_enumcodepages\r\nsp_executesql\r\nsp_fkeys\r\nsp_foreignkeys\r\nsp_fulltext_catalog\r\nsp_fulltext_column\r\nsp_fulltext_database\r\nsp_fulltext_service\r\nsp_fulltext_table\r\nsp_getapplock\r\nsp_getbindtoken\r\nsp_get_log_shipping_monitor_info\r\nsp_grantdbaccess\r\nsp_grantlogin\r\nsp_help\r\nsp_help_alert\r\nsp_help_category\r\nsp_helpconstraint\r\nsp_helpdb\r\nsp_helpdbfixedrole\r\nsp_helpdevice\r\nsp_help_downloadlist\r\nsp_helpextendedproc\r\nsp_helpfile\r\nsp_helpfilegroup\r\nsp_help_fulltext_catalogs\r\nsp_help_fulltext_catalogs_cursor\r\nsp_helpfulltext_columns\r\nsp_help_fulltext_columns_cursor\r\nsp_help_fulltext_tables\r\nsp_help_fulltext_tables_cursor\r\nsp_helpgroup\r\nsp_helphistory\r\nsp_help_job\r\nsp_help_jobhistory\r\nsp_help_jobschedule\r\nsp_help_jobserver\r\nsp_help_jobstep\r\nsp_helpindex\r\nsp_helpanguage\r\nsp_helplinkedsrvlogin\r\nsp_helplogins\r\nsp_help_maintenance_plan\r\nsp_help_notification\r\nsp_helpntgroup\r\nsp_help_operator\r\nsp_helpremotelogin\r\nsp_helprole\r\nsp_helprolemember\r\nsp_helprotect\r\nsp_helpserver\r\nsp_helpsort\r\nsp_helpsrvrole\r\nsp_helpsrvrolemember\r\nsp_helpstats\r\nsp_help_targetserver\r\nsp_help_targetservergroup\r\nsp_helptask\r\nsp_helptext\r\nsp_helptrigger\r\nsp_helpuser\r\nsp_indexes\r\nsp_indexoption\r\nsp_invalidate_textptr\r\nsp_linkedservers\r\nsp_lock\r\nsp_makewebtask\r\nsp_manage_jobs_by_login\r\nsp_monitor\r\nsp_MShasdbaccess\r\nsp_msx_defect\r\nsp_msx_enlist\r\nsp_OACreate\r\nsp_OADestroy\r\nsp_OAGetErrorInfo\r\nsp_OAGetProperty\r\nsp_OAMethod\r\nsp_OASetProperty\r\nsp_OAStop\r\nsp_password\r\nsp_pkeys\r\nsp_primarykeys\r\nsp_post_msx_operation\r\nsp_processmail\r\nsp_procoption\r\nsp_purgehistory\r\nsp_purge_jobhistory\r\nsp_reassigntask\r\nsp_recompile\r\nsp_refreshview\r\nsp_releaseapplock\r\nsp_remoteoption\r\nsp_remove_job_from_targets\r\nsp_remove_log_shipping_monitor\r\nsp_rename\r\nsp_renamedb\r\nsp_resetstatus\r\nsp_resolve_logins\r\nsp_resync_targetserver\r\nsp_revokedbaccess\r\nsp_revokelogin\r\nsp_runwebtask\r\nsp_server_info\r\nsp_serveroption\r\nsp_setapprole\r\nsp_setnetname\r\nsp_settriggerorder\r\nsp_scriptsubconflicttable\r\nsp_spaceused\r\nsp_special_columns\r\nsp_sproc_columns\r\nsp_srvrolepermission\r\nsp_start_job\r\nsp_statistics\r\nsp_stop_job\r\nsp_stored_procedures\r\nsp_tableoption\r\nsp_table_privileges\r\nsp_table_privileges_ex\r\nsp_tables\r\nsp_tables_ex\r\nsp_trace_create\r\nsp_trace_generateevent\r\nsp_trace_setevent\r\nsp_trace_setfilter\r\nsp_trace_setstatus\r\nsp_unbindefault\r\nsp_unbindrule\r\nsp_update_alert\r\nsp_update_category\r\nsp_updateexxtendedproperty\r\nsp_update_job\r\nsp_update_jobschedule\r\nsp_update_jobstep\r\nsp_update_log_shipping_monitor_info\r\nsp_update_log_shipping_plan\r\nsp_update_log_shipping_plan_database\r\nsp_update_notification\r\nsp_update_operator\r\nsp_updatestats\r\nsp_update_targetservergroup\r\nsp_updatetask\r\nsp_validname\r\nsp_validatelogins\r\nsp_who\r\nsp_xml_preparedocument\r\nsp_xml_removedocument\r\n复制存储过程\r\nxp_cmdshell\r\nxp_deletemail\r\nxp_enumgroups\r\nxp_findnextmsg\r\nxp_grantlogin\r\nxp_logevent\r\nxp_loginconfig\r\nxp_logininfo\r\nxp_msver\r\nxp_readmail\r\nxp_revokelogin\r\nxp_sendmail\r\nxp_sprintf\r\nxp_sqlagent_proxy_account\r\nxp_sqlmaint\r\nxp_sscanf\r\nxp_startmail\r\nxp_stopmail\r\n系统表\r\nbackupfile\r\nbackupmediafamily\r\nbackupmediaset\r\nbackupset\r\nlogmarkhistory\r\nlog_shipping_databases\r\nlog_shipping_monitor\r\nlog_shipping_plan_databases\r\nlog_shipping_plan_history\r\nlog_shipping_plans\r\nlog_shipping_primaries\r\nlog_shipping_secondaries\r\nMSagent_parameters\r\nMSagent_profiles\r\nMSarticles\r\nMSdistribution_agents\r\nMSdistribution_history\r\nMSdistributiondbs\r\nMSdistributor\r\nMSdynamicsnapshotjobs\r\nMSdynamicsnapshotviews\r\nMSlogreader_agents\r\nMSlogreader_history\r\nMSmerge_agents\r\nMSmerge_altsyncpartners\r\nMSmerge_contents\r\nMSmerge_delete_conflicts\r\nMSmerge_errorlineage\r\nMSmerge_genhistory\r\nMSmerge_history\r\nMSmerge_replinfo\r\nMSmerge_subscriptions\r\nMSmerge_tombstone\r\nMSpub_identity_range\r\nMSpublication_access\r\nMSpublications\r\nMSpublisher_databases\r\nMSqreader_agents\r\nMSqreader_history\r\nMSrepl_backup_lsns\r\nMSrepl_commands\r\nMSrepl_errors\r\nMSrepl_identity_range\r\nMSrepl_originators\r\nMSrepl_transactions\r\nMSrepl_version\r\nMSreplication_objects\r\nMSreplication_options\r\nMSreplication_queue\r\nMSreplication_subscriptions\r\nMSsnamshot_agents\r\nMSsnapshot_history\r\nMSsubscriber_info\r\nMSsubscriber_schedule\r\nMSsubscription_agents\r\nMSsubscription_articles\r\nMSsubscription_properties\r\nMSsubscriptions\r\nMSsub_identity_range\r\nMSsync_states\r\nrestorefile\r\nrestorefilegroup\r\nrestorehistory\r\nsysalerts\r\nsysaltfiles\r\nsysarticles\r\nsysarticleupdates\r\nsyscacheobjects\r\nsyscategories\r\nsyscharsets\r\nsyscolumns\r\nsyscomments\r\nsysconfigures\r\nsysconstraints\r\nsyscurconfigs\r\nsysdatabases\r\nsysdbmaintplan_databases\r\nsysdbmaintplan_history\r\nsysdbmaintplan_jobs\r\nsysdbmaintplans\r\nsysedpends\r\nsysedvices\r\nsysdownloadlist\r\nsysfiles\r\nsysfilegroups\r\nsysforeignkeys\r\nsysfulltextcatalogs\r\nsysindexes\r\nsysindexkeys\r\nsysjobhistory\r\nsysjobschedules\r\nsysjobs\r\nsysjobservers\r\nsysjobs\r\nsysjobservers\r\nsysjobsteps\r\nsyslanguages\r\nsyslockinfo\r\nsyslogins\r\nsysmembers\r\nsysmergepublications\r\nsysmergeschemaarticles\r\nsysmergeschemachange\r\nsysmergesubscriptions\r\nsysmergesubsetfilters\r\nsysmessages\r\nsysnotifications\r\nsysobjects\r\nsysoledbusers\r\nsysopentapes\r\nsysoperators\r\nsysperfinfo\r\nsyspermissions\r\nsysprocesses\r\nsysprotects\r\nsyspublications\r\nsysreferences\r\nsysremotelogins\r\nsysreplicationalerts\r\nsysschemaarticls\r\nsysservers\r\nsyssubscriptions\r\nsystargetservergroupmembers\r\nsystaOrgetservergroups\r\nsystargetservers\r\nsystaskids\r\nsystypes\r\nsysusers\r\nSYSTEM_USER\r\ntable\r\nTAN\r\ntext\r\nTEXTPTR\r\nTEXTVALID\r\ntimestamp\r\ntinyint\r\n跟踪标记\r\n事务\r\nTRIGGER_NESTLEVEL\r\nTRUNCATE TABLE\r\nTYPEPROPERTY\r\nUNICODE\r\nUNION\r\nuniqueidentifier\r\nUPDATE\r\nUPDATE STATISTICS\r\nUPDATETEXT\r\nUPPER\r\nUSE\r\nUSER\r\nUSER_ID\r\nUSER_NAME\r\nVAR\r\nvarbinary\r\nvarchar\r\nVARP\r\nWAITFOR\r\nWHERE\r\nWHILE\r\nWRITETEXT\r\nYEAR

无封面