Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22381 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
Do you think BCNF is better than 2NF & 3NF? Why?
How to convert character strings into numeric values?
What is partitioned view?
Characterize join and name diverse sorts of joins?
How to execute a stored procedure in ms sql server?
Explain the types of indexes.
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How will you find out if there are expensive SQL statements running or not?
What is the command dbcc checkdb used for?
What stored by the model?
Explain the xml support sql server extends?
Detail about the hardware which is supported by SQL server?
What is a trace frag?
What is sub-query in sql server?
what is a join and explain different types of joins? : Sql server database administration
