how to do all the arithmetic operations in a single stored .

If your problem is solved then make this post as answered..

Thanks

Renish

Here i explain you some arithmetic operations using store procedure in sql

create procedure [dbo].[mathsoperation]
as
begin

    DECLARE @a INT
    SET @a=20;
    DECLARE @b INT   
    SET @b=10;

SELECT

(@a+@b)AS Addition,
(@a-@b)AS Subtraction,
(@a*@b)AS Multiplication,
(@a/@b)AS Divison

end

 It solves your problem..

If you getting your ans then please make this post as answered

Thanks

Happy Coding...