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
Go to Top of Page
   

- Advertisement -