|
Posted by amish on 06/14/06 06:26
Stu wrote:
> It's generally not a good idea to dynamically create stored procedures;
> why are you trying to do that? Perhpas there's a better way to solve
> the problem you're trying to do.
>
> Stu
>
> cmay wrote:
> > I am writing some code generation stuff and I am trying to get a script
> > like this to work:
> >
> > IF (something)
> > BEGIN
> > CREATE PROCEDURE Whatever
> > AS
> > SELECT 1 as one
> > END
> >
> >
> > But it complains about this, so I am guessing that I can't put the
> > create prodcedure in an IF block.
> >
> > Does anyone know of a work around for this?
You can use dynamic sql
IF (something)
BEGIN
exec(' CREATE PROCEDURE Whatever
AS
SELECT 1 as one')
END
But procedures are generally permenent object and why are you
interested to create them on the fly?
Regards
Amish shah
Navigation:
[Reply to this message]
|