Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25197 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 difference between inner join and equi join?
How do I determine how many instances of sql server are installed on a computer?
What is snapshot report?
What you can do to delete a table without the delete trigger firing?
What are the key configuration files for sql server reporting services ?
How to download and install microsoft sql server management studio express?
What is autocommit mode in sql server?
Tell me extended events in sql server 2008?
What is the use of RDBMS?
What is the template in sql?
What is transaction server distributed transaction?
What are the tools available in market as an alternative to sql server reporting services?
Why is normalisation important?
What are different types of table joins?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
