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

wat new abt truncate in sql server

Question Posted / sandhyaparsaram

Answers were Sorted based on User's Feedback



wat new abt truncate in sql server..

Answer / praful chavan

While using TRUNCATE stmt, WHERE clause can not be used.
When we use TRUNCATE stmt, Trigger does not get fire. After
using TRUNCATE stmt, all the deleted rows are not entered in
the transaction log file(.ldf)

Is This Answer Correct ?    12 Yes 0 No

wat new abt truncate in sql server..

Answer / gk

Adding to the above answer truncate may or may not be
rolled back.
It can be rolled back if it is within a transaction.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

does physical index sort data

1 Answers  

Explain full-text indexing?

0 Answers  

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

What are the purposes and advantages stored procedure?

0 Answers  

What is a not null constraint?

0 Answers  

Differnce between sel server 2000 and 2005

3 Answers  

What are diverse clauses that form a part of sql?

0 Answers  

How adventureworkslt tables are related?

0 Answers  

What is a bit datatype?

0 Answers  

Explain rdbms?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories