What is the difference between truncate and delete statement?
- 6 Answers
- 7374 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 are different types of raid configurations? : Sql server database administration
How to execute a stored procedure in ms sql server?
Do you know sql server 2008 introduces automatic auditing?
What is indexed view? How to create it?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How to enter comments in transact-sql statements?
What happens if date-only values are provided as date and time literals?
Give an example of SQL injection attack ?
What is the difference in accessing db between sql server vs sql azure?
Does view occupy space?
What factors you will consider calculating the storage requirement for that view?
How to retrieve field values using mssql_result()?
Explain various data region available in ssrs with their use?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are the disadvantages of using querystrings to send data from one page to another?
