cueFlash

Glossary of SQL Server 7 - Session Level Options

Start Studying! Add Cards ↓

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

Add Cards

You must Login or Register to add cards