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

Question

how to do all the arithmetic operations in a single stored procedure. in sql server 2005

Renish Patel · Answer

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

Renish Patel · Answer

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...