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 |
|
insanepaul
Posting Yak Master
178 Posts |
 Posted - 2011-03-22 : 05:57:22
|
| Why do I get different data when opening a table to edit than doing a normal select? I'm sure the tables are the same (I dragged the table name into the select command)This is what I get:SELECT * FROM CORWEB_Transaction_ErrorResults:6152 2008-01-09 07:19:50.663 6153 2008-01-09 07:19:50.740 Open CORWEB_Transaction_Error table results in:7739 16/03/2011 01:24:03 |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2011-03-22 : 06:03:20
|
| Click on ! at the top of window which is "Execute SQL"it will give you fresh data.Vaibhav TIf I cant go back, I want to go fast... |
 |
|
|
insanepaul
Posting Yak Master
178 Posts |
Posted - 2011-03-22 : 06:22:07
|
quote:
Originally posted by vaibhavktiwari83
Click on ! at the top of window which is "Execute SQL"it will give you fresh data.Vaibhav T
stupidly i was connected to the wrong database |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2011-03-22 : 06:28:10
|
No problem Insanepaul  quote:
Originally posted by insanepaul
quote:
Originally posted by vaibhavktiwari83
Click on ! at the top of window which is "Execute SQL"it will give you fresh data.Vaibhav T
stupidly i was connected to the wrong database
Vaibhav TIf I cant go back, I want to go fast... |
|
|
|
|
|
|
open table v select * from table