Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1017


Write a query for primary key constraint with identity key word?

1011


What is application role in sql server database security? : sql server security

1037


What is a hint?

972


What are null values in ms sql server?

1058


Do you know nested transaction?

940


What stored procedure can you use to display the current processes?

873


What is join and name different type of joins?

1028


How to optimize stored procedure optimization?

877


Explain insert into select statement?

929


What are the mathematical functions supported by sql server 2005?

1045


Can We Use Data-grids For Our Report In Ssrs?

184


What is the syntax to execute the sys.dm_db_missing_index_details?

1000


Explain foreign key in sql server?

1000


What is ddl command?

956