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

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

Question Posted / bharathi

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

Please Help Members By Posting Answers For Below Questions

List the ways in which dynamic sql can be executed?

1014

How to get the query of a table in sql server?

898

How to trouble shoot if unable to connect SQL Server

1992

how to create “alternate row colour”?

146

How to check status of stored procedure in sql server?

988

Difference between report and query parameter. Why do we need different type of parameter?

953

What is a join in sql?

1092

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1266

Explain the third normal form(3nf)?

943

Can we add an identity column to decimal datatype?

1002

Why does sql studio use a single registered database repository? : sql server management studio

999

What is the difference between count and distinct count?

882

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

942

How can you check the level of fragmentation on a table?

1045

What are database states in ms sql server?

1180