What is the difference between truncate and delete statement?
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 another user execute your local temporary stored procedures?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is difference between unique and primary key?
What is a dbms wizard?
What do you understand by a view? What does the with check option clause for a view do?
What do you understand by coalesce in sql server?
Explain differentiate between a having clause and a where clause?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What are out-of-range errors with date and time literals?
What is a field name?
Why and when do stored procedure recompile?
What is query cost in sql server?
How do you handle datasets larger than 50 gb?
What is data compression? : sql server database administration
How will you hide an attribute? : sql server analysis services, ssas