Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8834 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
Can we use where clause in union?
What is normalization of database?
What is a partitioned view?
what is database replication? : Sql server database administration
How do I save a stored procedure in sql server?
What are truncate options available in sql server? : sql server database administration
What is difference between views and stored procedures?
What are the three different part of rdl file explain them?
What authentication modes does sql server support?
Is it possible to replicate data from sql server to oracle? : sql server replication
What are the requirements for sql server 2016?
Differentiate between sql temp table vs table variable?
How to insert multiple rows with a subquery?
What are the two authentication modes in sql server?
Explain query editor regions
