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 |
Write a sql query to get zero records from a table having n number of records?
How do you create a data source?
What is fill factor and pad index?
How to delete duplicate rows?
What is transaction server implicit?
Explain Active/Active and Active/Passive cluster configurations
How can you find out how many rows returned in a cursor?
What is difference between clustered index and non clustered index?
What is the importance of three tier architecture?
How can I enforce to use particular index?
What are the restrictions that views have to follow? : SQL Server Architecture
Write a sql query to display the current date?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)