Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can you tell me the difference between DELETE & TRUNCATE
commands?

Answer Posted / saradhi

Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back

Is This Answer Correct ?    5 Yes 47 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is perspective, have you ever created perspective? : sql server analysis services, ssas

911


Explain alternate key, candidate key and composite key in sql server?

912


What are number line correlation administrators will use while working with a subquery?

1174


How we can refresh the view?

1104


What are the limitations/drawbacks or ssrs 2008 r2?

139


what types of replication are supported in sql server? : Sql server database administration

1042


What are the differences between DDL, DML and DCL in SQL?

1227


Which are the new data types introduced in sql server 2008?

879


Explain iaas, paas and saas?

90


What happens if we shrink log file in sql server?

981


How to create new table with "create table" statements?

1098


What is query cost in sql server?

994


What is resultset concur_updatable?

1017


What is sql server management studio? : sql server management studio

1074


Why do we need normalization?

922