Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8889 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
how you can move data or databases between servers and databases in sql server? : Sql server administration
Can we insert data into a view?
What is named query? : sql server analysis services, ssas
Explain the truncate command?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is scan table/view and seek table/view when its occurs? : sql server database administration
How do I find the query plan in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to insert stored procedure result into temporary table?
What are joins in sql and what are the different types of joins?
How do you trace the traffic hitting a sql server?
what are database files and filegroups? : Sql server database administration
Explain timestamp datatype?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to add an address record into adventureworkslt?
