Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between truncate and delete statement?
- 6 Answers
- 8833 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
Explain acid?
What is the difference between delete and truncate statements?
How we can refresh the view?
What is for xml in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is an indexed view?
where can you add custom error messages to sql server? : Sql server administration
How to view existing indexes on an given table using sys.indexes?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the maximum number of index per table?
Is sql server is free?
Where to find ntwdblib.dll version 2000.80.194.0?
What is query optimizer in sql server?
What are different types of replication in sql server?
