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 the steps to take to improve performance of a poor performing query? : sql server database administration
Write a query for primary key constraint with identity key word?
What is application role in sql server database security? : sql server security
What is a hint?
What are null values in ms sql server?
Do you know nested transaction?
What stored procedure can you use to display the current processes?
What is join and name different type of joins?
How to optimize stored procedure optimization?
Explain insert into select statement?
What are the mathematical functions supported by sql server 2005?
Can We Use Data-grids For Our Report In Ssrs?
What is the syntax to execute the sys.dm_db_missing_index_details?
Explain foreign key in sql server?
What is ddl command?