Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/35

Click to flip

35 Cards in this Set

  • Front
  • Back
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