Differentiate between delete and truncate.
No Answer is Posted For this Question
Be the First to Post Answer
Tell me what are the essential components of sql server service broker?
Is sql server free?
Why use stored procedures in sql server?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Which one is faster delete/truncate? Why?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
If we delete pack Spec what will be the status of pack Body ?
How much is a sql server license?
What is a file group?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What are “phantom rows”?
what are different types of raid configurations? : Sql server database 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)