What is the diffrence between update_one and auto_fix?
- 3 Answers
- 11391 Views
- IBM, I also Faced
- E-Mail Answers
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
Why use identity in sql server?
How raid can influence database performance?
How to rebuild the master database?
How to convert numeric expression data types using the cast() function?
Does view occupy space?
do you know how to configure db2 side of the application? : Sql server database administration
what is spatial nonclustered index
What is temporary table in sql server? Why we use temp table?
Explain system functions or built-in functions? What are different types of system functions?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the properties of the transaction?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I find query history in sql server?
What is standby servers? Explain types of standby servers.
What are the different types of subquery?
