store procedure

Question

multiple store procedure in one procedure plz give any example

Manas Mohapatra · Answer

I am assuming that you are using SQLServer, if so here is the code: Main Procedure (It will call other StoredProcs) CREATE PROCEDURE [dbo].[usp_AddNewRecord] ( @AssetID AS INT ) AS BEGIN SET NOCOUNT ON; EXEC usp_AddInTemp1 @AssetID; EXEC usp_AddInTemp2 @AssetID; END ; Definition of usp_AddInTemp1 CREATE PROCEDURE [dbo].[usp_AddInTemp1] ( @AssetID AS INT ) AS BEGIN SET NOCOUNT ON ; -- Implement your logic END ; Definition of usp_AddInTemp2 CREATE PROCEDURE [dbo].[usp_AddInTemp2] ( @AssetID AS INT ) AS BEGIN SET NOCOUNT ON; -- Implement your logic END ;

Raja T · Answer

Hello Chandu, Try like sp1: create proc addn(@a float, @b float) as begin declare @sum varchar(4) set @sum=cast((@a+@b) as VARCHAR) print @sum END sp2: create proc subn(@a float, @b float) as begin declare @sub varchar(4) set @sub=cast((@a-@b) as VARCHAR) print @sub END sp3: create proc calc(@a float, @b float) as begin declare @tot varchar(10) exec addn @a,@b exec subn @a,@b END Checkout put like exec calc 50,40 Results 90 10

Francis · Answer

Can you add some more clarity on your question?

store procedure

Answers (3)