USE (Transact-SQL)

Changes the database context to the specified database or database snapshot in Microsoft SQL Server.

USE {database_name} [;]

SET ANSI_DEFAULTS ON

SET QUOTED_IDENTIFIER is modified depending on the value set to ANSI_DEFAULTS.

SET ANSI_DEFAULTS {ON | OFF}

SET QUOTED_IDENTIFIER (Transact-SQL)

Causes SQL Server to follow the ISO rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not generally allowed by the Transact-SQL syntax rules for identifiers.

SET QUOTED_IDENTIFIER { ON | OFF }

EXECUTE AS

When an EXECUTE AS statement is run, the execution context of the session is switched to the specified login or user name.

{ EXEC | EXECUTE } AS <context_specification> [;] <context_specification>::= { LOGIN | USER } = 'name' [ WITH { NO REVERT | COOKIE INTO @varbinary_variable } ] | CALLER

SQL block that contains USE followed by a SELECT statement.

SQL block that contains SET ANSI_DEFAULTS followed by a SELECT statement.

SQL block that contains SET QUOTED_IDENTIFIER followed by a SELECT statement.

SQL block that contains only session changing commands.

SQL block that contains EXEC AS followed by SELECT statement.