Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25170 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 39 Yes | 6 No |
Post New Answer View All Answers
Where the sql logs gets stored? : sql server database administration
Can We Use Data-grids For Our Report In Ssrs?
What is the process of normalising?
Tell me what is normalization? Explain different forms of normalization?
What are the different types of lock modes in sql server 2000?
Tell me what is sql profiler?
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
What happens if the update subquery returns no rows in ms sql server?
What are transactions and its controls?
What is bcp? When does it use?
Explain trigger classes i.e. Instead of and after trigger?
What are three major types of constraints?
How fixed length strings are truncated and padded?
What is a field name?
What is replace and stuff function in sql server?
