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

  • 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



    Bye
    Gabor