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 |
Repair mdf file
What is the difference between sdf and mdf?
What is forward - only cursors / read only cursor?
Can you explain some of the DTS problems?
Why use update_statistics command in sql server?
In which year relase the 7.0& 2000 & 2005?
Explain activity monitors
What is user defined datatypes and when you should go for them?
What are the types of database schema? : sql server analysis services, ssas
What is a partition function in sql server?
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply
What is store procedure? When do you use?