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 many columns can exist together per table?
How to create hyperlink from returned sql query ?
How to connect of datebase with sql express.?
What are the different types of subquery?
What is transaction server auto commit?
How to copy the tables, schema and views from one sql server to another?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is the difference between TRUNCATE and DROP?
How to create view in stored procedure sql server?
Explain differentiate between a having clause and a where clause?
Explain the dbcc pintable command when would you use it?
What is extent? Types of extents?
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)