Which of the following scenario makes use of BEGIN..END keyword redundant ?
A. when an IF statement controls the execution of multiple Transact-SQL statement
B. when an IF statement controls the execution of only one Transact-SQL statement
C. when an IF statement controls the execution of one or more Transact-SQL statement
D. None of the mentioned
Answer:A
Which of the following scenario makes use of BEGIN..END keyword redundant ?
A. when an IF statement controls the execution of multiple Transact-SQL statement B. when an IF statement controls the execution of only one Transact-SQL statement C. when an IF statement controls the execution of one or more Transact-SQL statement D. None of the mentioned
Explanation:Use the BEGIN and END statements anywhere a control-of-flow statement must execute a block of two or more Transact-SQL statements.