Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / vijay dev arya
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How do I clean up sql server transaction log?
do you know how to configure db2 side of the application? : Sql server database administration
what is dbcc? : Sql server database administration
what are acid properties? : Sql server database administration
What are out-of-range errors with date and time literals?
What is sql or structured query language?
what types of replication are supported in sql server? : Sql server database administration
Where to find ntwdblib.dll version 2000.80.194.0?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What are different types of collation sensitivity?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is use of except clause? How does it differ from not in clause?
How do I find the size of a sql server database?
How to store and query spatial data?
What is attribute? : sql server analysis services, ssas