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
Is sql server free?
What is merge?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
what is the system function to get current user's user id? : Sql server database administration
What do you understand by a stored procedure?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How would we use distinct statement? What is its use?
How does stuff differ from the replace function?
How to delete multiple rows with one delete statement in ms sql server?
What is stored in the mssqlsystemresource database? : sql server database administration
Explain the different types of joins?
what are the reporting service components in SSRS?
Tell me what is the significance of null value and why should we avoid permitting null values?
How except clause is differs from not in clause?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?