Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25125 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay dev arya
Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain user defined functions?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Does partitioning improve performance?
Can you explain various data region available in ssrs with their use?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is the current limitation of the size of SQL Azure DB?
What is left outer join in sql server joins?
What is 'Join' and explain its various types.
Explain nested join?
Where is my database stored on the hard disk in ms sql server?
What do you understand by the denormalisation?
Is null in sql server?
How can windows applications connect to sql servers via odbc?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How can I know what locks are running on which resource?
