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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between truncate and delete statement?

Question Posted / balaji t

Answer Posted / balaji t

Identity counter can be reset in truncate whereas it is not possible in delete.Truncate dont activate trigger whereas delete can be used in triggers.truncate is a DDL command whereas delete is a DML command.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain triggers?

942

What are types of scd? : sql server analysis services, ssas

973

What is sql server programming?

978

Does sql server use java?

995

What are the advantages of sql stored procedure?

1015

How do we Backup SQL Azure Data?

106

What is view in sql?

853

what are the different ways to return the rowcount of a table?

943

How can we delete Duplicate row in table?

999

What is scan table/view and seek table/view when its occurs? : sql server database administration

985

What are trace flags?

959

Does order by actually change the order of the data in the tables or does it just change the output?

1079

Explain different types of collation sensitivity?

924

What is system stored procedures?

978

ow to bring suspect mode datbase online from scratch

1762