What is the diffrence between update_one and auto_fix?
Answer Posted / karthik
Only members of the sysadmin fixed server role can specify
the Auto_Fix option. Only members of the sysadmin or
db_owner roles can specify the Update_One option.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the default order of an order by clause?
What are difference between Cluster index and Non-Cluster index?
How to receive returning result from a query?
Define ACID properties in a Database?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
define and explain the differences between clustered and non-clustered indexes.
Explain what are the authentication modes in sql server?
How to insert multiple rows with a subquery?
How to retrieve error messages using mssql_get_last_message()?
Explain differences between web edition and business edition?
What is primary key and example?
What is global temp table?
What is 'Join' and explain its various types.
Is it possible to update the views? If yes, how, if not, why?
How can we delete a table in sql server?