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
What is the most common trace flags used with sql server?
What is user-defined inline table-valued function?
How do you identify a foreign key?
What is NOT NULL Constraint in sql server 2012?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Mention what are the different types of ssrs reports?
where can you add custom error messages to sql server? : Sql server administration
What are the ways available in sql server to execute sql statements?
Tell me in brief how sql server enhances scalability of the database system?
How many levels of sp nesting are possible?
Why should you use or avoid select * statements?
What command would you use to create an index?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Tell me what are the essential components of sql server service broker?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?