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 |
If i am handling 150 servers then how to check the active jobs of all the servers?
How to write a query with a left outer join in ms sql server?
Explain how dts is used to extract, transform and consolidate data?
How to define output parameters in stored procedures?
What is the need for indexing?
How can you check the level of fragmentation on a table?
What causes index fragmentation?
What is an execution plan? When would you use it?
Which virtual table does a trigger use?
How can you list all the table constraints in a database?
What are sql server functions?
Can we use max in where clause?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)