query problem

• gupta1282

  Default port

  Points: 1465

  More actions

  September 30, 2009 at 8:08 am

  #98009

  Respected all

  I have some problem regarding query

  when i use

  select * from tablename

  records shows 0

  select * from tablename with (nolock)

  shows records

  Please Help Me

  thanks

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 30, 2009 at 8:14 am

  #1059970

  gupta1282 (9/30/2009)

  ---

  Respected all

  I have some problem regarding query

  when i use

  select * from tablename

  records shows 0

  select * from tablename with (nolock)

  shows records

  Please Help Me

  thanks

  could be a number of reasons, sounds like there is a transaction occuring on that table and you are seeing the commited and uncommited versions of the data

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  September 30, 2009 at 8:15 am

  #1059972

  Basically what's happening is that the table your querying is getting either updated with new records or getting modified by an update statement which locks the database. So when you query the table you see nothing, however when you use nolock you're basically looking at a cached read only version of it. Once the inserts/updates go through you should be able to query it without nolock.

  Please feel free to correct me if I'm wrong.

  Thanks,

  S

  --
  :hehe: