What is the difference between truncate and delete statement?
- 6 Answers
- 7363 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
Explain try...catch with sql server?
What is default constraint in ms sql server?
Can sql server be linked with other servers like oracle?
How global temporary tables are represented and its scope?
How can you fetch alternate records from a table?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the difference between count () and rowcount ()?
Explain Reporting Life Cycle?
what purpose does the model database serve? : Sql server database administration
What are the essential components of sql server service broker?
can a database be shrunk with users active? : Sql server administration
How does stuff differ from the replace function?
Can we use max in where clause?
What is the use of @@spid?
How do I perform an unattended install of sql server 2000?
