Create a Stored Procedure Inside Another Store Procedure 2

[MynameisLogan]

Here is a good one, I am new to SQL Server and I need to create a stored procedure that will create several stored procedures and triggers, does anyone know a way to do this or a place were I can find some reference on this.


Thanks

 

[Palmer]

The following code although very simplistic shows the general principles of creating a stored procedure within a stored procedure.

create procedure pproc
as
declare @cmd varchar (500)

select @cmd =
'create procedure newproc as select * from information_schema.columns'

exec (@cmd)
go

Hope this helps