Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25153 Views
- I also Faced
- E-Mail Answers
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 the full meaning of dml?
Where the sql logs gets stored?
Do you know what are the differences between lost updates and uncommitted dependencies?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Why use identity in sql server?
What is meant by indexing?
How to throw custom exception in Stored Procedure?
Explain how would you store your query in an SSRS report or a Database server?
What is cube dimension? : sql server analysis services, ssas
What is a ddl statement?
Can I use sql azure as a backup with log shipping or database mirroring?
What is a group function explain with an example?
What is normalization according to you and explain its different levels?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What is a rollup clause?
