Interested to Buy Any Domain ? << Click Here >> for more details...
What are the main control-of-flow T-SQL constructs?
- 1 Answers
- 4819 Views
- I also Faced
- E-Mail Answers
Answer / bharathi
IF...ELSE
IF (ex. IF EXISTS)
BEGIN...END
GOTO
RETURN
WAITFOR
WHILE
BREAK
CONTINUE
| Is This Answer Correct ? | 3 Yes | 0 No |
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Define compound operators?
Can store procedure call by user define function in SQL server?
Explain different types of locks in sql server.
How do you size a resultset?
Why use “nolock” in sql server?
How do I run sql server 2014?
What is default port number for sql server 2000?
Explain about sql server login?
How to insert and update data into a table with "insert" and "update" statements?
Explain table valued parameters in sql server? Why tvp used?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
-
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)
