Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiruthika
Yak Posting Veteran
67 Posts |
 Posted - 2007-12-28 : 05:00:18
|
| Hi! select * from rubberstock_tbl_shoppingcarttemp It dosent take datas from the table but select * from rubberstock_tbl_shoppingcarttemp (nolock) This querey takes the data from the tablewhat can i do to retrieve records through first query.I dont know whatis happening please explain and also dont know about nolockThanks in advance! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-28 : 05:45:52
|
| have you read about nolock hint in books on line?what don't you understand exactly?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2007-12-28 : 10:35:00
|
Once you have read all about how (nolock) allows you to read "uncommitted" transactions  , you will no doubt realize that you either have a logic problem in your processing or that have left a transaction out there in limbo (not committed or not rolled back)Be One with the OptimizerTG |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-28 : 22:41:09
|
| >> what can i do to retrieve records through first querySet isolation level to read uncommitted for the session. |
|
|
|
|
|
|
nolock problem