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 cdc in sql server?
What is right outer join in sql server joins?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
Explain what are the different index configurations a table can have?
About DTS usage ?
Why use identity in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what is a correlated sub-query? : Sql server database administration
How can you get @@error and @@rowcount at the same time?
Explain user defined functions?
What is the command used to get the version of sql server?
How will you know when statistics on a table are obsolete?
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)