|
Truncate
|
Delete
|
|
Truncate Table <Table Name>
|
Delete from <Table Name> Where
<Condition>
|
|
Cannot use Where Condition
|
It is possible
|
|
It Removes all the data
|
It deletes specified data if where
condition exists.
|
|
Faster in performance wise, because
it doesn't keep any logs
|
Slower than truncate because, it
keeps logs
|
|
Rollback is not possible
|
Rollback is possible
|
This blog provides MSBI stuff and Interview Questions. And especially you can get a lot of blog's URL on SSIS,SSAS & SSRS From different dedicators on MSBI.If you have any queries/concerns,please feel free to contact me at->kalluru.venkat@gmail.com
Saturday, 22 June 2013
Truncate Vs Delete
Labels:2013
Sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment