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 |
to explain sql server 2000 architecture & authentication
Explain identity in sql server?
How to make a remote connection in a database?
what is the system function to get current user's user id? : Sql server database administration
select top 5 * from emp order by newid() my question is , how this query get executed?
What is the difference between an index and a unique index?
What are indexers?
What is acid properties?
Do you know what are the differences between lost updates and uncommitted dependencies?
what are triggers? : Sql server database administration
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
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)