SET (T-SQL)

The Transact-SQL programming language provides several SET statements that alter the current session handling of specific information.

The SET statements are grouped into these categories.

Category Alters the current session settings for
Date and time Handling date and time data
Locking Handling Microsoft® SQL Server™ locking
Miscellaneous Miscellaneous SQL Server functionality
Query execution Query execution and processing
SQL-92 settings Using the SQL-92 default settings
Statistics Displaying statistics information
Transactions Handling SQL Server transactions

Date and Time Statements
SET DATEFIRST SET DATEFORMAT

Locking Statements
SET DEADLOCK_PRIORITY SET LOCK_TIMEOUT

Miscellaneous Statements
SET CONCAT_NULL_YIELDS_NULL SET LANGUAGE
SET CURSOR_CLOSE_ON_COMMIT SET OFFSETS
SET DISABLE_DEF_CNST_CHK SET PROCID
SET FIPS_FLAGGER SET QUOTED_IDENTIFIER
SET IDENTITY_INSERT  

Query Execution Statements
SET ARITHABORT SET NUMERIC_ROUNDABORT
SET ARITHIGNORE SET PARSEONLY
SET FMTONLY SET QUERY_GOVERNOR_COST_LIMIT
SET NOCOUNT SET ROWCOUNT
SET NOEXEC SET TEXTSIZE

SQL-92 Settings Statements
SET ANSI_DEFAULTS SET ANSI_NULLS
SET ANSI_NULL_DFLT_OFF SET ANSI_PADDING
SET ANSI_NULL_DFLT_ON SET ANSI_WARNINGS

Statistics Statements
SET FORCEPLAN SET STATISTICS IO
SET SHOWPLAN_ALL SET STATISTICS PROFILE
SET SHOWPLAN_TEXT SET STATISTICS TIME

Transactions Statements
SET IMPLICIT_TRANSACTIONS SET TRANSACTION ISOLATION LEVEL
SET REMOTE_PROC_TRANSACTIONS SET XACT_ABORT

Considerations When Using the SET Statements

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.