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
What is the difference between local and global temporary tables?
What method is used by the Command classes to execute SQL statements that return single values?
Difference between report and query parameter. Why do we need different type of parameter?
Explain indexes disadvantages?
What is the difference between ddl,dml and dcl commands?
What are the different types of locks in the database?
What are synonyms?
Who developed sql server?
How to scale out a federation by Sql statement?
What are views in ms sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is SQL Azure?
How many tables can be joined in SQL Server?
Why do we need normalization?
Your table has a large character field there are queries that use this field in their search clause what should you do?