Define cursor locking
No Answer is Posted For this Question
Be the First to Post Answer
How to use order by with union operators in ms sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
write a query to remove duplicate records without using primary key column?
from the table display the 2nd highest salary? and also the least 2nd salay?
What do you mean by COLLATION?
What is implicit mode in sql server?
Explain stored procedure?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain partitioned view?
What are the authentication modes in sql server? How can it be changed?
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)