what is the difference between Delete and Truncate
Answer Posted / anil sharma
Delete command execute row by row and it can't reset any
identity column's value.
But using Truncate command it reset all table and Identity
column also.So truncate command is fast then delete command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you trace the traffic hitting a sql server?
What is join query?
How to disable triggers using "disable trigger"?
How can windows applications connect to sql servers via odbc?
How can you know if the row fetched from cursor is still valid in underlying table?
How to write a query with a left outer join in ms sql server?
How secure is sql server database?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are alternate keys?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is difference between global temporary tables and local temporary tables?
How does recursive cte works in sql server?
Explain the architecture of ms sql reporting service?
How to turn off warning messages during php execution?
What are logical database components? : SQL Server Architecture