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...

how to implement locking in sql server

Answer Posted / suraj

like this

select *
from dbo.Address
with (nolock)

-- above query doesn't hold lock while retrieving data.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different methods available under sqlcommand class to access the data?

1057


Mention the differences between local and global temporary tables.

951


What is a derived table?

871


Write a SQL command to insert and update only a particular field?

1036


What is “asynchronous” communication in sql server service broker?

960


What are the tool windows in sql server management studio? : sql server management studio

1014


How is table type constraint applied to a table?

932


What is a database table?

924


Why is there a performance difference between two similar queries where one uses union and the other uses union all?

982


Is it true, that there is no difference between a rule and a check constraint?

972


What is a partitioned view?

948


What is set nocount on and what is set nocount off?

885


What is row_number()?

930


What are “lost updates”?

948


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1827