Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24964 Views
- I also Faced
- E-Mail Answers
Answer Posted / kapil
Delete: is a DML command.
Truncate: is a DDL command.
Delete & Truncate both can be rolled back.
Untill you have not commit transaction.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain “row_number()” in sql server with an example?
Explain user defined functions?
How to convert a unicode strings to non-unicode strings?
If a stored procedure is taking a table data type, how it looks?
How can I track the changes or identify the latest insert-update-delete from a table?
How to create a store procedure with encryption?
Does full backup break log chain?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How many levels of sp nesting is possible?
What are the advantages of user defined function?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is explicit cursors?
How to create user defined functions with parameters?
How to create a scrollable cursor with the scroll option?
