Query Analyzer..

Hi,
I am trying to write some queries in SQL Server 2005.
Is there any option like query analyzer?
Please guide me out..
Reg
ArijitUse SQL Server Management Studio (SSMS).
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Arijit" <arijit77@.gmail.com> wrote in message
news:1133700925.182636.231720@.g44g2000cwa.googlegroups.com...
> Hi,
> I am trying to write some queries in SQL Server 2005.
> Is there any option like query analyzer?
> Please guide me out..
> Reg
> Arijit
>|||Hi
In SQL Server Management Studio you have the New Query button or the
File/New/Database Engine Query options to give you a query window. Under
Tools/Options you have a range of settings for Query Execution.
You may want to look at the virtual lab "SQL Server 2005 Introduction to SQL
Server Management Studio" at
http://msdn.microsoft.com/vstudio/t...ql/default.aspx for an
introduction on how to use it.
John
"Arijit" <arijit77@.gmail.com> wrote in message
news:1133700925.182636.231720@.g44g2000cwa.googlegroups.com...
> Hi,
> I am trying to write some queries in SQL Server 2005.
> Is there any option like query analyzer?
> Please guide me out..
> Reg
> Arijit
>|||Arijit wrote:

> Hi,
> I am trying to write some queries in SQL Server 2005.
> Is there any option like query analyzer?
> Please guide me out..
> Reg
> Arijit
Management Studio. You can also still use SQL Server 2000 Query
Analyzer for many things. Some of the GUI features won't work but for
straight TSQL development it's just fine.
David Portas
SQL Server MVP
--|||VS 2005 also has it and it stays up instead of closing and poking the select
text in your window as SSMS does (unless I missed something in SSMS which is
likely). See the server explorer or new "Database project" in VS2005. An
interesting note is that a "SQL Server Project" will not give you this query
designer. I can only assume because that is geared for clr projects. But
it would have been nice to be able to use QA within that project and also be
able to just "Run" (instead of debug) queries to see the grid results pane.
William Stacey [MVP]
"Arijit" <arijit77@.gmail.com> wrote in message
news:1133700925.182636.231720@.g44g2000cwa.googlegroups.com...
> Hi,
> I am trying to write some queries in SQL Server 2005.
> Is there any option like query analyzer?
> Please guide me out..
> Reg
> Arijit
>|||William Stacey [MVP] (william.stacey@.gmail.com) writes:
> VS 2005 also has it and it stays up instead of closing and poking the
> select text in your window as SSMS does (unless I missed something in
> SSMS which is likely). See the server explorer or new "Database
> project" in VS2005. An interesting note is that a "SQL Server Project"
> will not give you this query designer. I can only assume because that
> is geared for clr projects. But it would have been nice to be able to
> use QA within that project and also be able to just "Run" (instead of
> debug) queries to see the grid results pane.
He asked about Query Analyzer, not Query Designer. The Query Designer
certainly deserves its name: it designs the queries according to its own
idea, and queries often come out with a different meaning than they
entered. Certainly nothing to recommend.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx