Hi,
I want to write a application works in same manner as SQL Query Analyzer
works in Text mode option. I studied the behavior of query analyzer and find
out that in text mode option query analyzer does not wait for the query to
get finished, for displaying the result.
It diplays the result in Text form as and when it gets the result. It works
in some different manner than Query Analyzer working in GRID option.
I also want to write a application which does not wait for all the results
of the query, just give me the records which are available right now and
then give the remaining ones also in similar chunks.
Query Analyzer must be using some API calls through which this is possible.
Can any one help me in figure out what APIs are used by query analyzer in
text mode option.
Any help is appreciated.
Thanks
PushkarTo the best of my knowledge, you cannot use ADO or ADO.NET for this. QA uses
ODBC, and I have a
feeling that it is possible using OLEDB as well. So pick up a programmers ma
nual for one of those
APIs and check for asynchronous execution. But you should carefully consider
the extra work to use
these low level APIs compared to the productivity of a higher level API.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Pushkar" <pushkartiwari@.gmail.com> wrote in message news:eSsFbyTMGHA.2704@.TK2MSFTNGP15.phx
.gbl...
> Hi,
> I want to write a application works in same manner as SQL Query Analyzer w
orks in Text mode
> option. I studied the behavior of query analyzer and find out that in text
mode option query
> analyzer does not wait for the query to get finished, for displaying the r
esult.
> It diplays the result in Text form as and when it gets the result. It work
s in some different
> manner than Query Analyzer working in GRID option.
> I also want to write a application which does not wait for all the results
of the query, just give
> me the records which are available right now and then give the remaining o
nes also in similar
> chunks.
> Query Analyzer must be using some API calls through which this is possible
.
> Can any one help me in figure out what APIs are used by query analyzer in
text mode option.
> Any help is appreciated.
> Thanks
> Pushkar
>
>|||Pushkar wrote:
> Hi,
> I want to write a application works in same manner as SQL Query Analyzer
> works in Text mode option. I studied the behavior of query analyzer and fi
nd
> out that in text mode option query analyzer does not wait for the query to
> get finished, for displaying the result.
> It diplays the result in Text form as and when it gets the result. It work
s
> in some different manner than Query Analyzer working in GRID option.
> I also want to write a application which does not wait for all the results
> of the query, just give me the records which are available right now and
> then give the remaining ones also in similar chunks.
> Query Analyzer must be using some API calls through which this is possible
.
> Can any one help me in figure out what APIs are used by query analyzer in
> text mode option.
> Any help is appreciated.
> Thanks
> Pushkar
It may help you to read:
http://www.aspfaq.com/show.asp?id=2120
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Good thinking, David. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1139910046.905427.137570@.g43g2000cwa.googlegroups.com...
> Pushkar wrote:
> It may help you to read:
> http://www.aspfaq.com/show.asp?id=2120
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
Showing posts with label analyzer. Show all posts
Showing posts with label analyzer. Show all posts
Thursday, March 29, 2012
Monday, March 12, 2012
How make Query Analyzer remember to be maximized?
First, if this isn't the appropriate group for this type of question,
please let me know which one is.
I'm running SQL 2000. When I start Query Analyzer, it always bring up
the query window in a non-maximized state, even though I always maximize
it each time. Is there any way to make QA remember that I want the
window to start up maximized? I know it isn't the biggest deal in the
world, but it's an irritation. Thanks for any help. p
** Posted from http://www.teranews.com **"Rav" wrote:
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up
> the query window in a non-maximized state, even though I always maximize
> it each time. Is there any way to make QA remember that I want the
> window to start up maximized? I know it isn't the biggest deal in the
> world, but it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **
>
Hi Rav
On my system (XP sp2) it will open in the same state as it was last closed.
If you always want to start a program maximized you can change the
properties on the start menu. Right clcik the Query Analyser and you will get
the properties dialog, change to the shortcut tab and you will see the run
option which has the options of "Normal window", "Maximized" or "Minimized".
Choose "Maximized" to always start as maximized.
John|||I don't think there's a way you can do to maximize Query Window everytime
you open QA.
--
Ekrem Önsoy
"Rav" <PaulR@.cais.com> wrote in message
news:ee0c8$480e048a$26520@.news.teranews.com...
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up the
> query window in a non-maximized state, even though I always maximize it
> each time. Is there any way to make QA remember that I want the window to
> start up maximized? I know it isn't the biggest deal in the world, but
> it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **|||Hi John,
I think OP asks for the Query Window in the QA, not the Query Analyzer
itself. You know, the Query Window always opens in a not maximized state.
But if you close the QA as maximized then when you open it again it opens
maximized... But the Query Window does not. This must be the one which
bothers the OP =)
--
Ekrem Ã?nsoy
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:AF2788B2-BC2A-411D-A75B-AEB91C60860F@.microsoft.com...
> "Rav" wrote:
>> First, if this isn't the appropriate group for this type of question,
>> please let me know which one is.
>> I'm running SQL 2000. When I start Query Analyzer, it always bring up
>> the query window in a non-maximized state, even though I always maximize
>> it each time. Is there any way to make QA remember that I want the
>> window to start up maximized? I know it isn't the biggest deal in the
>> world, but it's an irritation. Thanks for any help. p
>> ** Posted from http://www.teranews.com **
> Hi Rav
> On my system (XP sp2) it will open in the same state as it was last
> closed.
> If you always want to start a program maximized you can change the
> properties on the start menu. Right clcik the Query Analyser and you will
> get
> the properties dialog, change to the shortcut tab and you will see the run
> option which has the options of "Normal window", "Maximized" or
> "Minimized".
> Choose "Maximized" to always start as maximized.
> John|||Ekrem Ã?nsoy wrote:
> Hi John,
> I think OP asks for the Query Window in the QA, not the Query Analyzer
> itself. You know, the Query Window always opens in a not maximized
> state. But if you close the QA as maximized then when you open it again
> it opens maximized... But the Query Window does not. This must be the
> one which bothers the OP =)
>
Correct, Ekrem. The Query Analyzer window opens maximized just fine.
It's the initial Query window contained with that that doesn't remember
to open maximized. I saw your separate message saying that you don't
think there's a way to maximize the Query window each time I open QA.
Oh well. Thanks for the response (and to John also). p
.
** Posted from http://www.teranews.com **
please let me know which one is.
I'm running SQL 2000. When I start Query Analyzer, it always bring up
the query window in a non-maximized state, even though I always maximize
it each time. Is there any way to make QA remember that I want the
window to start up maximized? I know it isn't the biggest deal in the
world, but it's an irritation. Thanks for any help. p
** Posted from http://www.teranews.com **"Rav" wrote:
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up
> the query window in a non-maximized state, even though I always maximize
> it each time. Is there any way to make QA remember that I want the
> window to start up maximized? I know it isn't the biggest deal in the
> world, but it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **
>
Hi Rav
On my system (XP sp2) it will open in the same state as it was last closed.
If you always want to start a program maximized you can change the
properties on the start menu. Right clcik the Query Analyser and you will get
the properties dialog, change to the shortcut tab and you will see the run
option which has the options of "Normal window", "Maximized" or "Minimized".
Choose "Maximized" to always start as maximized.
John|||I don't think there's a way you can do to maximize Query Window everytime
you open QA.
--
Ekrem Önsoy
"Rav" <PaulR@.cais.com> wrote in message
news:ee0c8$480e048a$26520@.news.teranews.com...
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up the
> query window in a non-maximized state, even though I always maximize it
> each time. Is there any way to make QA remember that I want the window to
> start up maximized? I know it isn't the biggest deal in the world, but
> it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **|||Hi John,
I think OP asks for the Query Window in the QA, not the Query Analyzer
itself. You know, the Query Window always opens in a not maximized state.
But if you close the QA as maximized then when you open it again it opens
maximized... But the Query Window does not. This must be the one which
bothers the OP =)
--
Ekrem Ã?nsoy
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:AF2788B2-BC2A-411D-A75B-AEB91C60860F@.microsoft.com...
> "Rav" wrote:
>> First, if this isn't the appropriate group for this type of question,
>> please let me know which one is.
>> I'm running SQL 2000. When I start Query Analyzer, it always bring up
>> the query window in a non-maximized state, even though I always maximize
>> it each time. Is there any way to make QA remember that I want the
>> window to start up maximized? I know it isn't the biggest deal in the
>> world, but it's an irritation. Thanks for any help. p
>> ** Posted from http://www.teranews.com **
> Hi Rav
> On my system (XP sp2) it will open in the same state as it was last
> closed.
> If you always want to start a program maximized you can change the
> properties on the start menu. Right clcik the Query Analyser and you will
> get
> the properties dialog, change to the shortcut tab and you will see the run
> option which has the options of "Normal window", "Maximized" or
> "Minimized".
> Choose "Maximized" to always start as maximized.
> John|||Ekrem Ã?nsoy wrote:
> Hi John,
> I think OP asks for the Query Window in the QA, not the Query Analyzer
> itself. You know, the Query Window always opens in a not maximized
> state. But if you close the QA as maximized then when you open it again
> it opens maximized... But the Query Window does not. This must be the
> one which bothers the OP =)
>
Correct, Ekrem. The Query Analyzer window opens maximized just fine.
It's the initial Query window contained with that that doesn't remember
to open maximized. I saw your separate message saying that you don't
think there's a way to maximize the Query window each time I open QA.
Oh well. Thanks for the response (and to John also). p
.
** Posted from http://www.teranews.com **
Sunday, February 19, 2012
How get column headers in QA CSV export
Using Query Analyzer and SS 2000, if I export a query result set of a
SELECT to a CSV file is there any way to get the column names included as
the first line of the file?
Bill Todd
Bill Todd wrote:
> Using Query Analyzer and SS 2000, if I export a query result set of a
> SELECT to a CSV file is there any way to get the column names
> included as the first line of the file?
You can use the DTS import/export wizard for that.
David Gugick
Imceda Software
www.imceda.com
|||The only thing I have been able to get the DTS wizard to do is display the
error message "the value for a required parameter is missing" which is
really helpful. Is there any documentation for the beginner for DTS?
Bill Todd
David Gugick wrote:
> Bill Todd wrote:
> You can use the DTS import/export wizard for that.
|||Bill Todd wrote:[vbcol=seagreen]
> The only thing I have been able to get the DTS wizard to do is
> display the error message "the value for a required parameter is
> missing" which is really helpful. Is there any documentation for the
> beginner for DTS?
I'm not sure what problem you are having. The wizard is pretty simple to
use:
1- Select a server and a database
2- Select Text File as the destination and enter a text file name for
the output (CSV entension)
3 - Click Use a query to specify data to transfer
4 - Enter query, such as: Select * from sysobjects (or use query
builder)
5 - Click Delimited, Column Delimiter = TAB, and First Row Has Column
Names
6- Click Run Immediately (and possibly save DTS package for future use)
The file should be created in CSV format. Let us know if you have any
problems.
David Gugick
Imceda Software
www.imceda.com
SELECT to a CSV file is there any way to get the column names included as
the first line of the file?
Bill Todd
Bill Todd wrote:
> Using Query Analyzer and SS 2000, if I export a query result set of a
> SELECT to a CSV file is there any way to get the column names
> included as the first line of the file?
You can use the DTS import/export wizard for that.
David Gugick
Imceda Software
www.imceda.com
|||The only thing I have been able to get the DTS wizard to do is display the
error message "the value for a required parameter is missing" which is
really helpful. Is there any documentation for the beginner for DTS?
Bill Todd
David Gugick wrote:
> Bill Todd wrote:
> You can use the DTS import/export wizard for that.
|||Bill Todd wrote:[vbcol=seagreen]
> The only thing I have been able to get the DTS wizard to do is
> display the error message "the value for a required parameter is
> missing" which is really helpful. Is there any documentation for the
> beginner for DTS?
I'm not sure what problem you are having. The wizard is pretty simple to
use:
1- Select a server and a database
2- Select Text File as the destination and enter a text file name for
the output (CSV entension)
3 - Click Use a query to specify data to transfer
4 - Enter query, such as: Select * from sysobjects (or use query
builder)
5 - Click Delimited, Column Delimiter = TAB, and First Row Has Column
Names
6- Click Run Immediately (and possibly save DTS package for future use)
The file should be created in CSV format. Let us know if you have any
problems.
David Gugick
Imceda Software
www.imceda.com
Subscribe to:
Posts (Atom)