Hi all,

Please help me in solving following query.

Can we define in sql server the same parameter as input and output?

How to do it?

Thanks and regards,

Swapnil.

Hi All,

I have got the solution:

--objects
create proc usp1 @num int output as
set @num = @num + 1
go

--calculation
declare @num int
set @num = 7
exec usp1 @num output
select @num

--tidy
drop proc usp1
/*results
-----------
8
*/