SET commands

Command	Description
SET CONCAT_NULL_YIELDS_NULL	When SET CONCAT_NULL_YIELDS_NULL is ON, concatenating a null value with a string yields a NULL result.
SET IDENTITY_INSERT	Allows explicit values to be inserted into the identity column of a table. At any time, only one table in a session can have the IDENTITY_INSERT property set to ON.
SET QUOTED_IDENTIFIER	Causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks.
SET NOCOUNT	Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set.
SET ROWCOUNT	Causes SQL Server to stop processing the query after the specified numbers of rows are returned. Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in a future release of SQL Server.
SET ANSI_NULLS	When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = NULL returns zero rows even if there are null values in column_name. A SELECT statement that uses WHERE column_name <> NULL returns zero rows even if there are non-null values in column_name.
SET SHOWPLAN_ALL	Causes Microsoft SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements.
SET SHOWPLAN_TEXT	Causes Microsoft SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed.
STATISTICS IO	Causes SQL Server to display information regarding the amount of disk activity generated by Transact-SQL statements.
SET STATISTICS PROFILE	Displays the profile information for a statement. STATISTICS PROFILE works for ad hoc queries, views, and stored procedures. When STATISTICS PROFILE is ON, each executed query returns its regular result set, followed by an additional result set that shows a profile of the query execution.
SET STATISTICS TIME	Displays the number of milliseconds required to parse, compile, and execute each statement.
SET XACT_ABORT	Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error. When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back. Compile errors, such as syntax errors, are not affected by SET XACT_ABORT.
SET TRANSACTION ISOLATION LEVEL	Controls the locking and row versioning behavior of Transact-SQL statements issued by a connection to SQL Server.