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

If there is failure during updation of certain rows, what
will be the state?

Question Posted / guest

Answers were Sorted based on User's Feedback



If there is failure during updation of certain rows, what will be the state?..

Answer / guest

No changes will occur. So the data will be in previous
state only.

Is This Answer Correct ?    18 Yes 0 No

If there is failure during updation of certain rows, what will be the state?..

Answer / lu

The data will rollback

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

What are tasks?

3 Answers   Wipro,

What are the different types of sql server replication? : sql server replication

0 Answers  

What are subqueries in sql server?

0 Answers  

What is microsoft sql server?

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

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

0 Answers  

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

What is trace flag in sql server?

0 Answers  

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories