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 sql server authentication modes?

0 Answers  


What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,


What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,


How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,


how to do partition in sqlserver

0 Answers   TCS,






what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  


Do you know data definition language, data control language and data manipulation language?

0 Answers  


How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,


How to use group functions in the select clause in ms sql server?

0 Answers  


What is the difference between count and distinct count?

0 Answers  


Explain a checkpoint?

0 Answers  


tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  


Categories