Dynamic SQL in Stored Procedures

Dynamic SQL in Stored Procedures

am 03.11.2005 19:49:23 von Melissa Dougherty

------=_NextPart_000_003D_01C5E07D.65AE9040
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Will the stored procedures allow for building dynamic SQL (and =
executing).... similar to MS SQL Server?


Melissa
------=_NextPart_000_003D_01C5E07D.65AE9040--

Re: Dynamic SQL in Stored Procedures

am 03.11.2005 20:35:32 von SGreen

--=_alternative 006B9928852570AE_=
Content-Type: text/plain; charset="US-ASCII"

"Melissa Dougherty" wrote on 11/03/2005 01:49:23
PM:

> Will the stored procedures allow for building dynamic SQL (and
> executing).... similar to MS SQL Server?
>
>
> Melissa

It depends on which version of the server you are using. Please read:
http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions. html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 006B9928852570AE_=--