SQL Server 7 - Session Level Options

Start Studying!

Terms

undefined, object

copy deck

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

Start Studying!

Deck Info

Number of cards 35