Murach SQL Chapter 14

The name of a variable must start with which symbol?

@

______ statements must be in their own batch

CREATE

Use the ________ statement to create variables

DECLARE

If a statement must be executed before the statements that follow can succeed, you should include a _______ command

GO

The _______ statement signals the end of a batch

GO

Controls the flow of execution based on a condition

If/else

The initial value of a variable is always ______

NULL

You CAN use a table variable within which four statements?

SELECT, INSERT, UPDATE, DELETE

The scope of a local variable is _________________

The batch in which it's defined

A scalar variable contains __________

a single value

The scope of a derived table is within

a statement while the current statement is executing

A script can contain one or more ___________ that execute as a unit

batches

You CAN'T use a table variable within the __________ clause of a ____________ statement

into, select into

A table variable has _______ scope

local

A variable defined with the standard type is called a __________ variable

scalar

A series of SQL statements that you can store in a file

script

A table variable is only available within __________

the batch where it's declared

The scope of a temporary table is within

the system while the current database session is open

Repeats statements while a specific condition is true

while