What is the difference between truncate and delete statement?
- 6 Answers
- 6649 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / rajiv singh
Truncate deletes all rows from table. But Delete deletes
row/rows by condition.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is mean by candidate key?
What is data source view or dsv? : sql server analysis services, ssas
What is db stored procedure?
What is difference between rownum and rowid?
Do you know what are various aggregate functions that are available?
Explain various On-Delete options in a DB table. Which is the default option?
What are truncate options available in sql server? : sql server database administration
What is serializable?
What is relationship? What number of sorts of relationship are there?
How to create percentile function?
What are the advantages of policy management?
What is the purpose of indexing?
Can sql servers link to other servers?
In what version of sql server were synonyms released?
Write a sql query to sort on different column name according to the parameters passed in the function?
