Message
From
30/03/2000 08:21:21
To
29/03/2000 15:43:29
Miscellaneous
ID da thread:
00352359
ID da mensagem:
00352637
Views:
19
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
Using Dynamic SQL would look like this:
DECLARE @cmd varchar(2000)
SET @cmd = 'CREATE PROCEDURE HelloWorld AS ' +
'SELECT ''Hello World'''
EXECUTE( @cmd )
-Mike