Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25588 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
What do we need queues in sql service broker?
What are the different types of lock modes in sql server 2000?
What are the new scripting capabilities of ssms? : sql server management studio
Can we use max in where clause?
How to populate a table in sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the difference between getdate and sysdatetime?
How do I edit a procedure in sql server?
What do you understand by triggers and mention the different types of it?
Disadvantages of the indexes?
Explain the difference between function and stored procedure?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Explain Normalization and DE normalization
What are triggers in ms sql server?
