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 1695
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
| |