|
SET DATEFIRST |
changes SQL Servers understanding of the first day of the week |
|
|
SET CURSOR_CLOSE_ON_COMMIT |
when true cursors will automatically close when a transaction is committed |
|
|
SET NUMERIC_ROUNDABOUT |
Causes SQL Server to generate a warning or error when rounding an expression causes loss of precision |
|
|
SET ARITHABORT |
causes SQL Server to terminate a query when encountering div/0 or overflow |
|
|
SET NOEXEC |
causes SQL Server to compile a query and return any errors found without actually executing the query |
|
|
SET SHOWPLAN_TEXT |
produces an execution plan similar to SHOWPLAN_ALL with less detail. |
|
|
SET TEXTSIZE |
sets the amount of data, in bytes, that will be returned from a text or ntext field |
|
|
SET SHOWPLAN_ALL |
causes a detailed exectuion plan in the form of a hierarchical tree to be returned with the data |
|
|
SET IMPLICIT_TRANSACTIONS |
implicitly begins a transaction when certain statements are issued |
|
|
SET NOCOUNT |
prevents SQL Server from returning info messages about # of rows affected |
|
|
SET QUOTED_IDENTIFIERS |
causes SQL Server to interpret strings in double quotes as identifers rather than as literals. |
|
|
SET ANSI_NULL_DFLT_OFF |
causes columns in CREATE TABLE statements to default to not null |
|
|
SET STATISTICS_TIME |
returns amont of time it takes to parse, compile and execute statements in milliseconds |
|
|
SET CONCAT_NULL_YEILDS_NULL |
specifies whether a null value concatenatinated with a string returns null or an empty string |
|
|
SET ANSI_PADDING |
controls how strings are padded with extra spaces to fill fixed width columns |
|
|
SET LANGUAGE |
effects datetime formats and system messages for a session |
|
|
SET IDENTITY_INSERT |
allows you to explicitly insert values into identity columns |
|
|
SET LOCK_TIMEOUT |
sets the time to wait (in milliseconds) for blocking locks to be released before returning an error |
|
|
SET DEADLOCK_PRIORITY |
this is used to make queries from a specified connection more or less like to be a deadlock victim |
|
|
SET DATEFORMAT |
changes the way SQL Server interprets character strings in datetime conversions |
|
|
SET XACT_ABORT |
controls if SQL Server automatically rolls back transactions when a run-time error occurs |
|
|
SET TRANSACTION_ISOLATION_LEVEL |
controls the locking behavior in transactions |
|
|
SET QUERY_COVERNOR_COST_LIMIT |
sets a value, in seconds, that all queries must be completed within |
|
|
SET ROWCOUNT |
limits the number of rows processed by a query |
|
|
SET REMOTE_PROC_TRANSACTIONS |
causes SQL Server to begin a distributed transaction when a remote proc is executed in an existing transaction |
|
|
SET STATISTICS_IO |
returns info relating to the amount of disk activity a statement creates |
|
|
SET STATISTICS_PROFILE |
returns more info than SHOWPLAN_ALL. Additional columns relating to the number of rows processed |
|
|
SET FMTONLY |
causes SQL Server to return only the column headings |
|
|
SET PARSEONLY |
checks for syntax errors in statements-- doesnt compile statement like NOEXEC |
|
|
SET ANSI_NULLS |
controls whether a null value can be compared to itself-- yields null or t/f |
|
|
SET FORCEPLAN |
forces SQL Server to perform join opperations in the order they appear in the join statement |
|
|
SET ANSI_NULL_DFLT_ON |
columns in CREATE TABLE statements default to nullable |
|
|
SET ARITHIGNORE |
causes SQL Server to return an error message when it encounters div/0 or overflow |
|
|
SET ANSI_WARNINGS |
causes warnings to be generated for certain ansi-defined error conditions |
|
|
SET ANSI_DEFAULTS |
sets all sql 92 settings at once |
|
