Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8888 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / valarmathi
truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.
delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the rendering extensions of ssrs?
What is report rendering ?
How do you trace the traffic hitting a sql server?
How do I connect to sql server database?
what is a transaction? : Sql server database administration
What is the sql server 2000 version number?
Explain the different types of backups available in sql server? : sql server database administration
What is use of dbcc commands?
What are various aggregate functions that are available?
What is the difference between ddl and dml?
What is the partitioning method?
How and why use sql server?
What is the xml datatype?
Which is the latest version of sql server and when it is released?
Why does sql studio use a single registered database repository? : sql server management studio
