1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

which one will take 1st priority in case of insert statement
and select statement???

Question Posted / priyadarsini.indira

Answers were Sorted based on User's Feedback



which one will take 1st priority in case of insert statement and select statement???..

Answer / chigicherla mallikarjuna

select statement will take first priority

Is This Answer Correct ?    10 Yes 0 No

which one will take 1st priority in case of insert statement and select statement???..

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

Post New Answer

More SQL Server Interview Questions

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

What is unpivot?

0 Answers  

When would you use a before or after trigger?

0 Answers  

What is the difference between dataadapter and datareader?

0 Answers  

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,




Why use sub query in sql server and list out types of sub queries?

0 Answers  

Why is sql server log file full?

0 Answers  

How many types of database relationship in sql server?

0 Answers  

What is optimistic concurrency?

0 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

Explain features of analysis services?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories