Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22536 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
What is the xml datatype?
Where are full-text indexes stored?
Can sql server 2016 run on windows 7?
What is an inner join?
Can we add a cpu to sql server?
How to find table changes in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
what protocol both networks use? : Sql server database administration
How to create a simple stored procedure in ms sql server?
What are unicode character string data types in ms sql server?
What is the use of =,==,=== operators?
Is resultset an interface?
What is data source document?
What is dknf in normalization form?
What is default constraint in ms sql server?
