Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22391 Views
- I also Faced
- E-Mail Answers
Answer Posted / sachin patil
Truncate is DDL Command while Delete is DML Command
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
When you use @@error and try-catch?
Explain boyce and codd normal form(bcnf)?
Can a unique index be created on a column, which contains null?
What is importing utility?
How to create an index on a view?
How to create function with parameter in sql server?
What is difference in performance between insert top (n) into table and using top with insert?
How is table type constraint applied to a table?
Determine how to use the inserted and deleted pseudo tables?
How to convert a numeric expression from one data type to another?
What is encryption key?
What is multilevel indexing?
Is candidate a key?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Explain the types of indexes.
