RE: [Squirrel-sql-users] The stored procedures

[Colin B. <Col...@as...>]

To create a stored procedure in SQuirreL means executing a CREATE =
PROCEDURE
SQL statement. Something like

CREATE OR REPLACE PROCEDURE PROC01=20
AS=20
SELECT * FROM TAB01;

Consult the documentation that came with your SQL server for more
information.

To retrieve the source for your stored procedure is a little trickier. =
There
is no vendor-neutral way using JDBC to retrieve the source for a stored
procedure. Instead you'll have to consult the documentation that came =
with
your SQL server to see how to do this. Usually its stored in a table in =
your
system database.

Col

> -----Original Message-----
> From: aj...@wo... [mailto:cz0...@ti...]
> Sent: Thursday, 7 August 2003 17:07
> To: squ...@li...
> Subject: [Squirrel-sql-users] The stored procedures
>=20
>=20
> Please can someone tell me how I can create and edit the=20
> stored procedures
> in Squirrel? Thanks.
>=20
>=20
> Betty
>=20
>=20
> ___________________________________________________________________
> Nakreslete si svoji mapu a vyhrajte ceny z letn=ED kolekce!
> Soutezte s MapClubem na http://mapy.tiscali.cz
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites =
including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet
> _072303_01/01
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>=20