Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25124 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
How would you add a section to a table?
What’s the distinction between dropping a info and taking a info offline?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How do I create a stored procedure in dbml?
Define Wed Edition in SQL Azure?
Define inner join? Explain with an example?
What are triggers? How do you invoke a trigger on demand?
what is denormalization and when would you go for it? : Sql server database administration
What is an expression in ms sql server?
Explain about protocol layer present in SQL server?
What will be the maximum number of index per table?
What is primary key, unique key, and foreign key?
Can you explain the disadvantages/limitation of the cursor?
How many clustered indexes there can be on table ?
What are partitioned views?
