Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9089 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
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
How to insert multiple rows with a subquery?
How do I create a stored procedure in sql server?
how to invoke a trigger on demand? : Sql server database administration
Which table keeps information about stored procedures?
Explain some stored procedure creating best practices or guidelines?
What is normalization? Describe its different types.
What are the different methods available under sqlcommand class to access the data?
How to download and install the scaled-down database adventureworkslt?
How do you test your database? : sql server database administration
What is implicit cursors?
Difference between group by clause and having clause in SQL?
What do we have to check in database testing?
How can i Relate Tables in SSIS
What are magic tables in sql server?
what is hash nonclustered index
