Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9092 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / balaji t
Identity counter can be reset in truncate whereas it is not possible in delete.Truncate dont activate trigger whereas delete can be used in triggers.truncate is a DDL command whereas delete is a DML command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the differences between local and global temporary tables.
What is triggers and stored procedures?
How to manipulate data from one table to another table ?
What are different types of database indexes?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Can a table have 2 foreign keys?
Can We Use Data-grids For Our Report In Ssrs?
What are the advantages of policy management?
What is sub query and its properties?
What is the difference between a function and a stored procedure?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How you can move data or databases between servers and databases in sql server?
Where is trigger in sql server?
What is a not null constraint?
What are the difficulties faced in cube development? : sql server analysis services, ssas
