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 some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

930


What is primary key index?

917


What is the sql server agent?

1031


What is a rownum?

892


What are the different types of columns types constraints in the sql server?

1004


How to verify a login name with sqlcmd tool?

1125


New concepts of sql server 2005 use in your project.

2303


How do you create type- insensitive operator?

989


What is acid mean in sql server?

1033


What are system databases into sql server (2005/2008)?

952


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

967


Explain go command in sql server?

964


What are secondary xml indexes?

983


Explain the different types of backups available in sql server? : sql server database administration

862


Write a SQL query in order to merge two different columns into single column?

988