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 diffrence between update_one and auto_fix?

Question Posted / aviral nalwat

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 will you go about resolving deadlocks?

971

Explain the cursor lock types?

1058

Explain about nested stored procedure?

1032

How to use the inserted and deleted pseudo tables?

963

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

889

What are the different types of triggers in SQL SERVER?

1139

How to convert character strings into numeric values?

1097

What is the purpose of a table?

959

How to count duplicated values in a column in ms sql server?

1095

can a table be moved to different filegroup? : Sql server administration

979

Why do we use stored procedures in sql server?

943

What is sql server database?

1015

How to update muliple row in single query?

1060

How many databases Microsoft SQL server provides?

1091

Explain what are magic tables in sql server?

998