Home Forums SQL Server 7,2000 T-SQL How Create a store procedure from another store procedure RE: How Create a store procedure from another store procedure
Gabor Nyul
SSCrazy Eights
Points: 9459
More actions
January 11, 2004 at 4:21 am
#489534
Yes there is a way to create a stored from from an another SP
create proc sp1
as
declare @STR varchar(1000)
set @STR = 'create proc sp2 as select * from t'
exec (@str)
go
ByeGabor