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


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

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

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,


What are examples of triggers?

0 Answers  


Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  


what is web server?

3 Answers   Satyam,


What is the dbcc command and why is it used?

0 Answers  


What is log shipping?

0 Answers  


What are pessimistic lock and optimistic lock?

0 Answers  


What is service broker? : sql server database administration

0 Answers  


Explain indexed views?

0 Answers  


Differentiate between a having clause and a where clause.

0 Answers  


What is user defined datatypes and when you should go for them?

0 Answers  


Explain few examples of RDBMS?

0 Answers   Wipro,


Categories