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

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

Repair mdf file

2 Answers  


What is the difference between sdf and mdf?

0 Answers  


What is forward - only cursors / read only cursor?

0 Answers  


Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,


Why use update_statistics command in sql server?

0 Answers  






In which year relase the 7.0& 2000 & 2005?

1 Answers  


Explain activity monitors

0 Answers  


What is user defined datatypes and when you should go for them?

0 Answers  


What are the types of database schema? : sql server analysis services, ssas

0 Answers  


What is a partition function in sql server?

0 Answers  


Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,


What is store procedure? When do you use?

0 Answers  


Categories