Stored Procedures

[Vayse]

Hi Folks
So what do you ADP guys use to write your Update, Append etc Queries?
Is there a graphical tool like there is in normal access?
Have a fairly complex Update to run, and I don't want to write it all in
SQL.
Thanks
Diarmuid

 

[Sylvain Lafontaine]

There are no more a graphical tool to write complex SQL queries and SP that
there is one to write complex VBA code.

The graphical tool used in normal access can be used only with the most
simple cases. Even something as usual and simple as an UNION cannot be
created with it.

 

[Vayse]

A pity.
Are there any graphical tools to write simpler queries? Just wondering is
there some third party tool that was any use.

 

[Vadim Rapp]

V> Are there any graphical tools to write simpler queries? Just wondering
V> is there some third party tool that was any use.

No. In fact, Access is probably the most capable of all.

I use Enterprise Manager.

Vadim Rapp

 

[Vadim Rapp]

SL> Even something as usual and simple as an UNION cannot be created with
SL> it.

Sylvain, I'm curious, how would you draw UNION query graphically? it's not
an argument, just curious how it might look.

Vadim

 

[Sylvain Lafontaine]

A slight misunderstanding here: I never said that the actual graphical tool
should be improved but that usually any graphical tool will be more of an
hindrance than to be useful as soon as you have to write anything but simple
queries.

As to the specific problem of drawing an Union query graphically, the actual
SQL-Server query plans are quite capable of displaying them; so I don't see
why this should be an impossible task to do.

 

[Robert Morley]

I would see it as either multiple windows for each subquery, or possible
something similar to a join line, only it would be a union line. Not the
easiest thing to build into a graphical UI, but I'm sure it could be done
with time.



Rob