Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / saradhi
Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back
Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
What is a primary index?
What is the difference between locking and multi-versioning?
What is the need for group functions in sql?
How self join is different from outer join?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How do I view views in sql server?
explain different types of cursors? : Sql server database administration
What is indexing in sql server with example?
Explain index in sql server?
How to locate and take substrings with charindex() and substring() functions?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is meant by indexing files?
What are the advantages of sql stored procedure?
What is awe?
why would you call update statistics? : Sql server database administration