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 |
Explain sql server authentication modes?
What are the types of subscriptions in SQL Server replication?
What is storeprocedure?Tell me synatx for how to write stored procedure.
How to avoid cursors?
3 Answers CarrizalSoft Technologies, HP,
how to do partition in sqlserver
what are user defined datatypes and when you should go for them? : Sql server database administration
Do you know data definition language, data control language and data manipulation language?
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
How to use group functions in the select clause in ms sql server?
What is the difference between count and distinct count?
Explain a checkpoint?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration