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 |
What is difference between cte and view?
Find top Nth employee from each department in terms of salary?
How to declare and use cursor variables?
How to filter out duplications in the returning rows in ms sql server?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
Can you name a few encryption mechanisms in sql server?
What is a collation in ms sql server?
What is "scheduled jobs" or "scheduled tasks"?
Explain relational data?
what is a transaction and what are acid properties? : Sql server database administration
Determine when an index is appropriate?
What is instead of trigger sql server?
Oracle (3259)
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)