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 |
SET DATEFIRST | SET DATEFORMAT |
SET DEADLOCK_PRIORITY | SET LOCK_TIMEOUT |
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 |
SET ARITHABORT | SET NUMERIC_ROUNDABORT |
SET ARITHIGNORE | SET PARSEONLY |
SET FMTONLY | SET QUERY_GOVERNOR_COST_LIMIT |
SET NOCOUNT | SET ROWCOUNT |
SET NOEXEC | SET TEXTSIZE |
SET ANSI_DEFAULTS | SET ANSI_NULLS |
SET ANSI_NULL_DFLT_OFF | SET ANSI_PADDING |
SET ANSI_NULL_DFLT_ON | SET ANSI_WARNINGS |
SET FORCEPLAN | SET STATISTICS IO |
SET SHOWPLAN_ALL | SET STATISTICS PROFILE |
SET SHOWPLAN_TEXT | SET STATISTICS TIME |
SET IMPLICIT_TRANSACTIONS | SET TRANSACTION ISOLATION LEVEL |
SET REMOTE_PROC_TRANSACTIONS | SET XACT_ABORT |