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

What is the diffrence between update_one and auto_fix?

Answer Posted / aviral nalwat

AUTO_FIX matches based on the user alias in the DB to a
login account.

UPDATE_ONE allows you to specify the alias mapping to the
login account.

See BOL for more detail if needs be.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of built in functions are there in sql server 2012?

871


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

951


What is Lock table in SQL?

1406


What is faster join or union?

1102


what are user defined datatypes? : Sql server database administration

922


What are the properties and different types of sub-queries?

957


How many types of triggers in sql server?

968


What are the system database in sql server 2008?

974


What is the default Port No on which SQL Server listens?

1065


what are the critical issues you have resloved in your company

1920


Write SQL queries on Self Join and Inner Join.

1070


Name and describe few console utilities for ssrs?

274


What is the native system stored procedure to execute a command against all databases?

967


System requirements for sql server 2005 express edition?

950


What is constraints and its types?

875