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 |
What is bulkcopy in sql?
Explain transaction server implicit?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
What is the difference between a "where" clause and a "having" clause?
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??
Why do we backup Active Directory ?
WHAT OPERATOR PERFORMS PATTERN MATCHING?
2 Answers CarrizalSoft Technologies, CTS,
When you first load SQL SERVER you will startup with what all databases?
to explain sql server 2000 architecture & authentication
explain how to create a new schema in a database? : Sql server database administration
Why use update_statistics command in sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Oracle (3253)
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)