Référence du langage : Nouvelles rubriques et rubriques mises à jour (14 avril 2006)

Nouveau : 14 avril 2006

Dans la version 14 avril 2006 de la documentation en ligne de SQL Server, les rubriques suivantes ont été ajoutées à la documentation en ligne ou ont fait l'objet de modifications importantes.

Catégories de rubrique

Nouvelles rubriques de référence

Rubriques de référence mises à jour

Nouvelles rubriques de référence

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)

Retour en haut

Rubriques de référence mises à jour

@@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 et 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 et 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)

Clause ORDER BY (Transact-SQL)

POWER (Transact-SQL)

RECONFIGURE (Transact-SQL)

Procédures stockées de réplication (Transact-SQL)

RESTORE (Transact-SQL)

Arguments RESTORE (Transact-SQL)

Exemples 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)

Indicateur de table (T-SQL)

table_constraint (Transact-SQL)

Indicateurs de trace (Transact-SQL)

TRY...CATCH (Transact-SQL)

WHILE (Transact-SQL)

XACT_STATE (Transact-SQL)

Retour en haut