Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8887 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
How to execute a sql statement using odbc_exec()?
Is sql server implemented as a service or an application? : Sql server database administration
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
what is the main function of a query parameter?
What is DCL?
Can we add a cpu to sql server?
What is the difference between getdate and sysdatetime?
What is the difference between implicit and explicit transaction?
Explain the phases a transaction has to undergo?
What language is sql server written in?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is the stuff and how does it differ from the replace function?
What is a natural primary key?
What are the database roles? : sql server security
Explain try...catch with sql server?
