Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8536 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / ismail hasan
truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.
Delete statement will delete a particular row(s) on your
choice.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are truncate options available in sql server? : sql server database administration
What is a database table?
What are the differences between web role and worker role?
Define tool Manage Statistics in SQL Server 2000 query ?
what are cursors? : Sql server database administration
Which language rdl files made of?
What is the new security features added in sql server 2014? : sql server security
what is a transaction? : Sql server database administration
Do you know what is bit data type and whats the information that can be stored inside a bit column?
what are the different types of SSRS reports?
What is the maximum size of a row in sql server?
What is factless fact table? : sql server analysis services, ssas
What happens to a statement batch if there is a compilation error?
What are the benefits of filtered indexes?
Tell me what is the order in which the sql query is executed?
