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 |
|
radhi3274
Starting Member
1 Post |
 Posted - 2010-08-12 : 02:18:23
|
| Hi all,I am running query select * from some tableIt is giving me 20 records and after some time i check it is giving me the other count..Why this is hapening ...cause for this problem?RegardsRadhika |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-12 : 02:35:20
|
The data is changing...that's normal isn't it?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-13 : 10:15:49
|
quote:
Originally posted by radhi3274
Hi all,I am running query select * from some tableIt is giving me 20 records and after some time i check it is giving me the other count..Why this is hapening ...cause for this problem?RegardsRadhika
Why do you think this is a problem?MadhivananFailing to plan is Planning to fail |
|
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-14 : 01:33:36
|
quote:
it is giving me the other count..
quote:
Originally posted by webfred
The data is changing...that's normal isn't it?
No, you're never too old to Yak'n'Roll if you're too young to die.
in which cases it will happen this is first time i am seeing such a postWith RegardsKashyap M |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-14 : 04:22:22
|
| if you are running this on production server (live server where transactions are happening from second to second) it is normal that each time you wil execute the query, you will get different number. |
|
|
|
|
|
|
Retrieving me different count of rows effected