Dear experts,
I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.
When I was using my query analyzer last, a few months ago, I
was tuning some strange code. I changed some settings to
see what was going on.
Now, when I login, and do a query, I see lots of tuning info. see: http://www.geocities.com/dba_222/querya.jpg
But I don't see any output from the query at all!!!!
Yes, there is data in the table, as my coworker does get
a number from the query.
Is this familiar to anyone?
Can anyone tell me what the setting is, that I need to change back,
in order to see the output?
I'm sure it's either a SET command, or a setting in Query Analyzer.
Thanks a lot! 3  1697 
CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.
Cheers,
Johan Sjöström
MCP, MCAD
dba_...@yahoo.com wrote:
Dear experts,
I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.
When I was using my query analyzer last, a few months ago, I
was tuning some strange code. I changed some settings to
see what was going on.
Now, when I login, and do a query, I see lots of tuning info. see:
http://www.geocities.com/dba_222/querya.jpg
But I don't see any output from the query at all!!!!
Yes, there is data in the table, as my coworker does get
a number from the query.
Is this familiar to anyone?
Can anyone tell me what the setting is, that I need to change back,
in order to see the output?
I'm sure it's either a SET command, or a setting in Query Analyzer.
Thanks a lot!
Thanks for responding.
That did something. But it didn't bring the results back.
It toggled the output I had on the bottom, to just the query.
I think I figured it out. I toggled
menu, query, show execution plan
That gave me the results (of the query), or the execution plan.
But not both.
Johan Sjöström wrote:
CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.
Cheers,
Johan Sjöström
MCP, MCAD
You may want to go to [Tools], [Options]
Click on [Editor], then select [Tabbed Mode].
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<db*****@yahoo.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Thanks for responding.
That did something. But it didn't bring the results back.
It toggled the output I had on the bottom, to just the query.
I think I figured it out. I toggled
menu, query, show execution plan
That gave me the results (of the query), or the execution plan.
But not both.
Johan Sjöström wrote:
CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.
Cheers,
Johan Sjöström
MCP, MCAD
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Nils Benson |
last post by:
Here's a strange problem:
I have an arbitrary query that has calculated columns in its output.
It could be a "SELECT TOP 1 * FROM ...", or a "SELECT STDEV(somefield)
FROM ...". It doesn't matter...
|
by: Ixnay |
last post by:
Hi,
Does anyone out there know how to do this? I've been banging head for
awhile now trying to answer this seemingly simple question.
tia,
Mike
|
by: Philip Yale |
last post by:
A colleague of mine has a query which fails to run under SQLAgent
batch with the following error:
The conversion of a char data type to a datetime data type resulted in
an out-of-range datetime...
|
by: Robert Brown |
last post by:
suppose I have the following table:
CREATE TABLE (int level, color varchar, length int, width int, height
int)
It has the following rows
1, "RED", 8, 10, 12
2, NULL, NULL, NULL, 20...
|
by: MichaelC |
last post by:
Hi all,
I'm a newbie to SQL and I need help with investigating what ways are
possible to build an interface of some sort that wraps around a SQL
query script.
I have a simple SQL query which...
|
by: AG |
last post by:
I am able to run a query which runs FAst in QA but slow in the
application.It takes about 16 m in QA but 1000 ms on the
Application.What I wanted to know is why would the query take a long
time...
|
by: dba_222 |
last post by:
Dear experts,
I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.
When I was using my query analyzer last, a few months ago, I...
|
by: Frawls |
last post by:
Hi
I Am am having problems with a stored Procedure that i wrote.
Basically whats happening is that the Stored procedure Runs fine when i
EXECUTE it in SQL Query analyzer.
But when i debug...
|
by: jambonjamasb |
last post by:
Hi
I have two tables:
email_tbl
Data_table
Data table is is used to create a Form
Data_form
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
