GUI tools for Query Analyser

17 Mar 2005 10:25 PM

Paul

I am new to SQL but have some experience with MS Access.

Instead of writing codes in Query Analyser, is there any
GUI tools (maybe 3nd party) for designing queries ?

17 Mar 2005 10:32 PM

Simon Worth

If you want to see graphically what you are doing, you can use
Enterprise manager, but it's pretty limited to what it will display.

--
Simon Worth

Paul wrote:

Show quote

> I am new to SQL but have some experience with MS Access.
>
> Instead of writing codes in Query Analyser, is there any
> GUI tools (maybe 3nd party) for designing queries ?

17 Mar 2005 10:39 PM

Paul

Dear Simon,

Thank you for your advice. Do you suggest to use the
designer with "View" in EM ?

Thanks

Show quote

>-----Original Message-----
>If you want to see graphically what you are doing, you
can use
>Enterprise manager, but it's pretty limited to what it
will display.
>
>
>--
>Simon Worth
>
>Paul wrote:
>> I am new to SQL but have some experience with MS Access.
>>
>> Instead of writing codes in Query Analyser, is there
any
>> GUI tools (maybe 3nd party) for designing queries ?
>.
>

18 Mar 2005 3:28 AM

Aaron [SQL Server MVP]

I don't.
http://www.aspfaq.com/2455

There is no substitute for learning the SQL dialect instead of trying to
accomplish WYSIWYG...

On 3/17/05 5:39 PM, in article 180601c52b42$24159fc0$a6012***@phx.gbl,
Show quote

"Paul" <anonym***@discussions.microsoft.com> wrote:

> Dear Simon,
>
> Thank you for your advice. Do you suggest to use the
> designer with "View" in EM ?
>
> Thanks
>
>> -----Original Message-----
>> If you want to see graphically what you are doing, you
> can use
>> Enterprise manager, but it's pretty limited to what it
> will display.
>>
>>
>> --
>> Simon Worth
>>
>> Paul wrote:
>>> I am new to SQL but have some experience with MS Access.
>>>
>>> Instead of writing codes in Query Analyser, is there
> any
>>> GUI tools (maybe 3nd party) for designing queries ?
>> .
>>