语言参考：新的和已更新的主题（2006 年 4 月 14 日）

新建日期： 2006 年 4 月 14 日

在 2006 年 4 月 14 日 版本的 SQL Server 联机丛书中，联机丛书中添加了以下主题或进行了重要更改。

主题类别

新的参考主题

更新的参考主题

新的参考主题

DecryptByKeyAutoAsymKey (Transact-SQL)

DecryptByKeyAutoCert (Transact-SQL)

sp_add_jobschedule (Transact-SQL)

sp_dbmmonitoraddmonitoring (Transact-SQL)

sp_dbmmonitorchangealert (Transact-SQL)

sp_dbmmonitorchangemonitoring (Transact-SQL)

sp_dbmmonitordropalert (Transact-SQL)

sp_dbmmonitordropmonitoring (Transact-SQL)

sp_dbmmonitorhelpalert (Transact-SQL)

sp_dbmmonitorhelpmonitoring (Transact-SQL)

sp_dbmmonitorresults (Transact-SQL)

sp_dbmmonitorupdate (Transact-SQL)

sp_unsetapprole (Transact-SQL)

sys.dm_exec_cached_plan_dependent_objects

sys.dm_exec_query_memory_grants

sys.dm_exec_query_resource_semaphores

sys.dm_exec_xml_handles

sys.fn_translate_permissions (Transact-SQL)

sys.openkeys (Transact-SQL)

sys.securable_classes (Transact-SQL)

返回页首

更新的参考主题

@@DATEFIRST (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER TABLE (Transact-SQL)

BACKUP (Transact-SQL)

BETWEEN (Transact-SQL)

BULK INSERT (Transact-SQL)

CASE (Transact-SQL)

CAST 和 CONVERT (Transact-SQL)

CHECKSUM (Transact-SQL)

column_constraint (Transact-SQL)

COLUMNS_UPDATED (Transact-SQL)

computed_column_definition (Transact-SQL)

CONTAINS (Transact-SQL)

CREATE FUNCTION (Transact-SQL)

CREATE INDEX (Transact-SQL)

CREATE TABLE (Transact-SQL)

CREATE TRIGGER (Transact-SQL)

CREATE TYPE (Transact-SQL)

CREATE VIEW (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DATEADD (Transact-SQL)

DBCC CHECKALLOC (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC CHECKIDENT (Transact-SQL)

DBCC CHECKTABLE (Transact-SQL)

DBCC CLEANTABLE (Transact-SQL)

DBCC INDEXDEFRAG (Transact-SQL)

DBCC SHRINKDATABASE (Transact-SQL)

DBCC SHRINKFILE (Transact-SQL)

DELETE (Transact-SQL)

DROP TYPE (Transact-SQL)

EncryptByAsymKey (Transact-SQL)

EXECUTE (Transact-SQL)

FREETEXT (Transact-SQL)

IDENT_CURRENT (Transact-SQL)

int、bigint、smallint 和 tinyint (Transact-SQL)

ISNUMERIC (Transact-SQL)

KILL (Transact-SQL)

NEWSEQUENTIALID()

NSNotificationBatchDetails (Transact-SQL)

NULLIF (Transact-SQL)

OBJECT_ID (Transact-SQL)

OPENDATASOURCE (Transact-SQL)

OPENQUERY (Transact-SQL)

OR (Transact-SQL)

ORDER BY 子句 (Transact-SQL)

POWER (Transact-SQL)

RECONFIGURE (Transact-SQL)

复制存储过程 (Transact-SQL)

RESTORE (Transact-SQL)

RESTORE 参数 (Transact-SQL)

SELECT 示例 (Transact-SQL)

SERVERPROPERTY (Transact-SQL)

SESSIONPROPERTY (Transact-SQL)

SET ARITHABORT (Transact-SQL)

SET QUERY_GOVERNOR_COST_LIMIT (Transact-SQL)

SET TRANSACTION ISOLATION LEVEL (Transact-SQL)

sp_add_jobstep (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_addarticle (Transact-SQL)

sp_addmergearticle (Transact-SQL)

sp_changearticle (Transact-SQL)

sp_changemergearticle (Transact-SQL)

sp_databases (Transact-SQL)

sp_dbcmptlevel (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_dropserver (Transact-SQL)

sp_help_fulltext_system_components (Transact-SQL)

sp_helpconstraint (Transact-SQL)

sp_lock (Transact-SQL)

sp_notify_operator (Transact-SQL)

sp_refreshview (Transact-SQL)

sp_special_columns (Transact-SQL)

sp_testlinkedserver (Transact-SQL)

sp_who (Transact-SQL)

sp_xml_preparedocument (Transact-SQL)

sys.all_columns (Transact-SQL)

sys.all_parameters (Transact-SQL)

sys.column_type_usages

sys.columns (Transact-SQL)

sys.database_mirroring (Transact-SQL)

sys.dm_broker_queue_monitors

sys.dm_clr_properties

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_exec_connections

sys.dm_exec_sql_text

sys.dm_os_hosts

sys.dm_os_schedulers

sys.dm_os_tasks

sys.dm_os_wait_stats

sys.dm_os_workers

sys.fulltext_languages (Transact-SQL)

sys.master_files (Transact-SQL)

sys.parameter_type_usages

sys.parameters (Transact-SQL)

sys.servers (Transact-SQL)

sys.syscacheobjects (Transact-SQL)

sys.sysobjects (Transact-SQL)

sys.sysprocesses (Transact-SQL)

sys.system_columns (Transact-SQL)

sys.system_parameters (Transact-SQL)

sys.systypes (Transact-SQL)

sys.type_assembly_usages

sys.types (Transact-SQL)

sysarticles (Transact-SQL)

sysmail_delete_mailitems_sp (Transact-SQL)

sysmail_help_principalprofile_sp (Transact-SQL)

表提示 (Transact-SQL)

table_constraint (Transact-SQL)

跟踪标志 (Transact-SQL)

TRY...CATCH (Transact-SQL)

WHILE (Transact-SQL)

XACT_STATE (Transact-SQL)

返回页首