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 file group?
How to find the second highest salary of an employee?
What should be the fill factor for indexes created on tables? : sql server database administration
What command would you use to add a column to a table in sql server?
Explain what is the use of custom fields in report?
List the different normalization forms?
Explain data warehousing in sql server?
What are the new data types are introduced in sql 2000?
How to turn on the mssql api module in php?
Is the primary key column of a table an index in ms sql server?
What are trace flags?
What is normalization? Describe its different types.
what is a traditional network library for sql servers? : Sql server database administration
What is the difference between dataadapter and datareader?
How do I know if localdb is running?