Additon of two integers using SP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Additon of two integers using SP

Author

Topic

chinlax
Starting Member

30 Posts

Posted - 2011-11-24 : 06:36:52

Hi all,

I have written the stored procedure like this.
CREATE PROC usp_AddTwoInteger10 @FirstNumber int ,
@SecondNumber int, @Answer int OUTPUT as

Declare @sum int
Set @sum = @FirstNumber + @SecondNumber

Return @sum

Declare @a int, @b int, @c int
Select @a = 2, @b = 4
Exec usp_AddTwoInteger10 @a, @b, @c OUTPUT
Select @c

whats wrong in this stored procedure
its giving output as null

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-11-24 : 06:53:19

CREATE PROC usp_AddTwoInteger10 @FirstNumber int ,
@SecondNumber int, @Answer int OUTPUT as

Set @Answer = @FirstNumber + @SecondNumber

Return

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources