What is the difference between truncate and delete statement?
Answer Posted / sreejith s t
Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What happens if null values are involved in bitwise operations?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is checkpoint in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What stored by the model?
Does union all remove duplicates?
Are all views updatable ?
how many type of indexing in database?
How do you send email on SQL Server?
Is it possible in sql table to have more than one foreign key?
Where cross join is used?
What are clustered and non-clustered index?
What is normalization? What number of normalization shapes are there?
What is join query?
Differentiate between a primary key and a unique key.