which one will take 1st priority in case of insert statement
and select statement???
Answers were Sorted based on User's Feedback
Answer / chigicherla mallikarjuna
select statement will take first priority
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
How to perform backup for certificates in sql server? : sql server security
What is the difference between varchar and nvarchar?
How to delete the duplicate rows from a table in SQL Server ??
Explain what is dbcc?
How do I debug a stored procedure in sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What are the pre-defined functions in the sql server?
What are the diifferences between the ms sql server vs mysql?
What is a domain constraint give an example?
What are transactions in sql?
What is rolap and its advantage? : sql server analysis services, ssas
How to check if stored procedure is running in sql server?