which one will take 1st priority in case of insert statement
and select statement???
Answer Posted / sandeep
I think that depends on locking system we choose. if we
implement high data availability then select statement will
wait for the completeion of insert or update statement. I
dont remember those locking systems rite now.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is primary key index?
What is the sql server agent?
What is a rownum?
What are the different types of columns types constraints in the sql server?
How to verify a login name with sqlcmd tool?
New concepts of sql server 2005 use in your project.
How do you create type- insensitive operator?
What is acid mean in sql server?
What are system databases into sql server (2005/2008)?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain go command in sql server?
What are secondary xml indexes?
Explain the different types of backups available in sql server? : sql server database administration
Write a SQL query in order to merge two different columns into single column?