Chapter 14

SCALAR

A local variable that can store a single value is called a/an ____________ variable.

TABLE VARIABLE

A local variable that can store an entire result set is called a/an ____________ variable.

SCRIPT

A series of SQL statements that you can store in a file is called a/an ____________.

tempdb

A temporary table is stored in the system database named ___________.

BEGIN/END

If you need to execute 2 or more SQL statements within and IF or ELSE clause, enclose them with a ___________ block.

TRUE

TRUE OR FALSE: The following statement assigns the value "Test" to a scalar variable named @Name that's declared with the varchar data type. SET @Name = 'Test';

TRUE

TRUE OR FALSE: The following statement changes the database context to a database named TestDB. Use TestDB;

TRUE

TRUE OR FALSE: The following statement creates a table variable named @TestTable. Var @TestTable table;

FALSE, a local variable is limited to the BATCH in which it is defined

TRUE OR FALSE: The scope of a local variable is limited to the database session in which it's defined.

FALSE, to return a message use the PRINT statement

TRUE OR FALSE: To return a message to the client, you use the WRITE statement.

IF/ELSE

To control the flow of execution based on a true/false condition, you code a/an ___________ statement.

GO

To divide a script into multiple batches, you use the __________ command.

TRY/CATCH

To handle errors caused by one or more SQL statements, you can use the ___________ statement.

WHILE

To repeatedly execute a statement or set of statements, you code a/an ___________ statement.

@@IDENTITY

To return the value of the most recently assigned identity column, you can use the ___________ system function.