Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9063 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
how will add additional conditions in sql?
How to rebuild the master database?
Can sql server be linked with other servers like oracle?
What is rank function?
What are “unrepeatable reads”?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What stored by the model?
Do you know hot add cpu in sql server 2008?
List out what other servers you can use with ssrs?
What is the cpu pressure?
Explain query editor regions
What is the difference between functions and stored procedures?
what is the difference between openrowset and openquery?
Which table keeps the locking information?
What do you mean by an execution plan? Why is it used? How would you view it?
