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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2008-08-21 : 12:02:24
|
| When I select a table through the object explorer and choose select all rows the query editor is showing the statement that executes along with the data. The query is in the top pane and the data on the bottom. All that I want is the data to be returned. Is there anyway to turn this feature off? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:27:58
|
| Don't think so. |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2008-08-22 : 09:26:40
|
| Found the answer. You must choose "Edit top N records" This brings back the results without the query in the top section. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-22 : 09:29:46
|
| But for better performance do this in Query Analyser using a queryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Object Explorer selecting all rows from table