Programming & Software Support
- Enabling SMS Feature for China Unicom VN007+ 5G Modem
- Generating Running Balance or Statement of Acount in SQL
- Model Binded Custom HTML Helper for C# MVC
- Easyworship 2009 fix for Windows 10 Nov. 2015 Update
- Simple way of encrypting and decrypting sensitive data using phrase
- HTML Color Chart
- Getting The Last Column Of The Last Row Of A Table with jQuery
- Microsoft SQL Server Transactional and Merge Replication step by step
- Check for duplicates before inserting a record
- Creating Stored Procedure with Output Variable
Categories
Create a stored procedure that will add 2 variables
CREATE PROCEDURE SumVariables
@var1 INT,
@var2 INT,
@varTotal INT OUTPUT
AS
BEGIN
SET @varTotal = COALESCE(@var1,0) + COALESCE(@var2, 0)
END
Call the sumVariables procedure
DECLARE @result INT
EXEC sumVariables 2,3, @result OUTPUT
SELECT @result
Back To Programming & Software Support