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




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

Post New Answer

More SQL Server Interview Questions

Explain what is log shipping?

0 Answers  


WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  


Define constraints and give an example of their use?

0 Answers  


Creating Tables Using SELECT

1 Answers  


How to connect php with different port numbers?

0 Answers  






what is the different types of backups available in sql server? : Sql server database administration

0 Answers  


check, not null,unique

2 Answers   IBM,


What is side by side migration in sql server?

0 Answers  


last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  


Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  


Diffrent types of function

1 Answers   Wipro,


Categories