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 |
|
SunnyDee
Yak Posting Veteran
79 Posts |
 Posted - 2007-06-26 : 09:02:54
|
| Has anyone ever come across this before? Select * from table only shows 2 records, but if I open the table in Mgmt. Studio, there are 3 records. What could be the cause of this? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-26 : 09:19:06
|
| Did you set rowcount to 2 and forget to rest?Try thisSet rowcount 0Select * from tableMadhivananFailing to plan is Planning to fail |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2007-06-26 : 10:53:56
|
| Is the third row populated with actual data, or does it show: NULL for each of the columns? I think Mgmt studio does that to allow you to enter new row, but it isn't a new row...Fight the darkside - don't edit tables in SSMS ( or EM)...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
select * not showing all records