Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 9091 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / vasu
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is tempdb database? : SQL Server Architecture
What is the new security features added in sql server 2016? : sql server security
Where to find ntwdblib.dll version 2000.80.194.0?
Explain the stored procedure?
What are the results of running this script?
What are the common performance issues in sql server?
Where do we use trace frag?
How to use the inserted and deleted pseudo tables?
What is a result set object returned by odbc_exec()?
What are wait types?
What is meant by indexing files?
What is sql injection and why is it a problem? : sql server security
How do I view a stored procedure in sql server?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Is it true, that there is no difference between a rule and a check constraint?
