same Parameter of Stored procedure as input/outpu

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 2000 Forums

Import/Export (DTS) and Replication (2000)

same Parameter of Stored procedure as input/outpu

Author

Topic

Azhar Iqbal
Starting Member

2 Posts

Posted - 2009-06-03 : 07:14:50

dear all,
Can I use one parameter for input and output purpose at the same time in stored Procedure.
Thanks
Azhar
Pakistan

Left elbow has cut.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-03 : 09:08:36

Like this

create procedure test(@inout int out)
as
select @inout= @inout*2

go

declare @i int
set @i=45
select @i
exec test @i output
select @i

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources