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


Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How is sql server used?

691


What is the security principal at the database level that represents your session?

700


Does any body please help me what question's have asked for SSRS in the interview?

1872


How to drop existing indexes in ms sql server?

754


What is the difference between index seek vs. Index scan?

765






Explain different backup plans?

701


What is the log shipping?

749


why would you use sql agent? : Sql server database administration

767


Does a full backup include transaction log?

678


How to bind a view to the schema of the underlying tables?

754


Can a function call a stored procedure in sql server?

697


How can I check that whether automatic statistic update is enabled or not?

780


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

664


How to link tables in sql server?

654


How to insert data with null values?

762