What is the difference between deallocate cursor and close cursor?
No Answer is Posted For this Question
Be the First to Post Answer
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is sql server profiler?
How ssrs maintain security?
How to remove duplicate rows from table except one?
How to remove duplicate rows from table?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Can primary key be a foreign key?
What is repeatable read?
Detail about query optimizer?
Is truncate a dml command?
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)