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 is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Does a specific recovery model need to be used for a replicated database? : sql server replication
Why de-normalization required?
Explain data warehousing in sql server?
Why I have to use stored procedures?
What is transactional replication?
Can you explain what are commit and rollback in sql?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is the exact numeric data type in sql?
In what sequence sql statement is processed?
What is dbcc command in sql server?
can an order by clause be used in a creation of a view?
How do you rebuild an identity column?
Do you know what is sql injection?
Explain contrast amongst grouped and non-bunched records?