What are the main control-of-flow T-SQL constructs?

Question Posted / renjusha

What are the main control-of-flow T-SQL constructs? ..

Answer / bharathi

IF...ELSE
IF (ex. IF EXISTS)
BEGIN...END
GOTO
RETURN
WAITFOR
WHILE
BREAK
CONTINUE

Is This Answer Correct ?

3 Yes

0 No

More SQL Server Interview Questions

What is Check point? Explain in Brief what it will do?

Is it possible in sql table to have more than one foreign key?

What are “lost updates”?

What is candidate key with example?

You want to implement the one-to-one relationship while designing tables. How would you do it?

What is it unwise to create wide clustered index keys?

What are xml indexes?

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

Is a primary key unique?

What are the advantages of using stored procedures in sql server?

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

How do I trace a query in sql server?

For more SQL Server Interview Questions Click Here