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
Explain what is use of dbcc commands?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is index in an assignment?
What is normalization? Describe its different types.
What is the difference between deallocate cursor and close cursor?
What command would you use to create an index?
How you can get a list of all the table constraints in a database?
What are scalar functions?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What command is used to delete a table from the database in the sql server and how?
What is inner join in sql server joins?
What is difference between index seek vs. Index scan?
what are different types of backups available in sql server? : Sql server database administration
What are relationships and mention different types of relationships in the dbms
How to insert multiple rows with one insert statement in ms sql server?