Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create stored procedures
Message
From
30/03/2000 08:21:21
 
 
To
29/03/2000 15:43:29
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00352359
Message ID:
00352637
Views:
16
You might try using the Execute() command and dynamic SQL but if you can call the outer stored procedure (The one that you want to pass parameters to) then why not just submit the CREATE PROCEDURE command.

Using Dynamic SQL would look like this:

DECLARE @cmd varchar(2000)

SET @cmd = 'CREATE PROCEDURE HelloWorld AS ' +
'SELECT ''Hello World'''

EXECUTE( @cmd )

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform