Can you tell me the difference between DELETE & TRUNCATE
commands?
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 SQL Azure?
Explain where clause?
What is database isolation in sql server? : sql server database administration
What do you mean by stored techniques? How would we use it?
What are the types of lock supported by ?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How to stop log file growing too big?
How will you find out if there are expensive SQL statements running or not?
What is raid and what are different types of raid levels?
What is dbcc? Give few examples.
What is sql server profiler?
What security features are available for stored procedure?
How would we use distinct statement? What is its use?
What is xml datatype?
How does clustered and non clustered index work?