Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24577 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil
Delete Commands:
it is dml statement
you can specify delete command with critery (where
condition)
syntax: Delete * from tablename where condition
Truncate Command:
it is DDL statement
you can not specify critery with truncate table
syntax: truncate table tablename
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is right outer join in sql server joins?
How many types of stored procedures are there in sql server?
What are the disadvantages of using the stored procedures?
How to send email from database?
‘Order by’ is not allowed in a view how can you sort information from a view?
What are diverse clauses that form a part of sql?
Explain about thread and memory management process of SQL?
what are defaults? : Sql server database administration
What is the maximum number of index per table?
What is table constraint?
What is sql injection? How to protect against sql injection attack?
What is a schema in ms sql server 2005?
How can we determine what objects a user-defined function depends upon?
How to add the custom code in Report?
What are the dmvs? : sql server database administration
