which one will take 1st priority in case of insert statement
and select statement???
- 2 Answers
- 5784 Views
- HCL, I also Faced
- E-Mail Answers
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 does COMMIT command do?
What is query optimization process?
Explain powershell included in sql server 2008?
What is the difference between composite index and covering index?
How much space does sql server 2016 take?
Define Wed Edition in SQL Azure?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Do you know what guidelines should be followed to help minimize deadlocks?
When you use @@error and try-catch?
Explain Geometry datatype in sql server 2008 with example
What do you understand by recursive stored procedures?
How do I view a stored procedure in sql server query?
Does partitioning ssd reduce performance?
how to create “alternate row colour”?
What is sql server schema compare? How we can compare two database schemas?
