Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22941 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nageswarao
truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How to create a simple table to test triggers in ms sql server?
what is the system function to get current user's user id? : Sql server database administration
How to fetch the next row from a cursor with a "fetch" statement?
Explain few examples of stored procedure over triggers?
Explain features of analysis services?
How to see the event list of an existing trigger using sys.trigger_events?
What are the kinds of subquery?
What is a print index?
what are the types of indexes? : Sql server database administration
What is the query and subquery?
what is a mixed extent? : Sql server administration
Explain what are various ways to enhance the ssrs report?
How many joins in sql server?
Write a query for primary key constraint with identity key word?
How you can change a cross join into an inner join?
