Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8540 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 to assign null values to variables or columns?
What are the new features in sql server 2016?
How do you Implement SSIS Packages in your Project?
How to execute a stored procedure in ms sql server?
Explain tables in SQL Azure?
How efficient you are in oracle and SQL server?
How do I schedule a sql server profiler trace?
SQL Server Architecture ?
What is the Difference Between Primary and Foreign Key?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Explain the truncate command?
How much space does sql server 2016 take?
How use inner join in sql server?
