Member Avatar for Swapnil Palande

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.

  • 1 Contributor
  • 1 Reply
  • 75 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Swapnil Palande
Member Avatar for Swapnil Palande

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
*/

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.