--CREATE A FUNCTION FOR ADD TWO USER INPUT VALUES. CREATE FUNCTION AddFun_sp(@NumIst INT, @NumpIInd INT) RETURNS INT AS BEGIN DECLARE @Result as int SET @Result=@NumIst+@NumpIInd RETURN @Result END --CALL A FUNCTION IN STORE PROCEDURE. CREATE PROCEDURE usp_CallAfunction ( @IstVar INT, @IIndVar INT ) AS BEGIN DECLARE @sp AS INT SET @sp=dbo.AddFun1(@IstVar,@IIndVar) PRINT @sp END --EXECUTE STORE PROCEDURE FOR OUTPUT RESULT. EXECUTE dbo.usp_CallAfunction '10', '20' --RESULT IS 30
» Are you preparing for Angular Interview? Buy this book (Including Angular 8, 7, 6, 5,4, 2) Interview Q/A Interview Q/A Interview Q/A Interview Q/A Interview Q/A Interview Q/A Interview Q/A » A Complete Guide Book of Angular 9 This is a concise, complete overview of the key aspects of Angular 9. It is fully up to date with the latest release of Angular. This article provide all the important aspects required for angular developers looking for brief and useful content... Posted In Angular 9 » A Complete Guide Book of Angular 8 This is a concise, complete overview of the key aspects of Angular 9. It is fully up to date with the latest release of Angular. This article provide all the important aspects required for angular developers looking for brief and useful content... Posted In Angular 8 » A Complete Guide Book of Angular 7 This is a concise, complete overview of the key aspects of Angular 7. It is fully up to date with the latest release of Angular. This