What are the different types of lock modes in sql server 2000?
No Answer is Posted For this Question
Be the First to Post Answer
List all types of constraints in sql server?
What is pessimistic concurrency?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Is it possible to create trigger on views?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Tell me what is use of except clause? How it differs from not in clause?
What is the return type of executeupdate ()?
What is the stored procedure?
What is Self Join?
What is blocking and how would you troubleshoot it? : sql server database administration
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
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)