ALTER procedure [dbo].[Test] (@name varchar(50),@sal int ) as begin select Sal from Salary where Name=@name end
ALTER procedure [dbo].[Test] (@name varchar(50),@sal int out ) as begin select @Sal = Sal from Salary where Name=@name end
exec Test 'Name to pass', 0
ALTER procedure [dbo].[Test] (@name varchar(50) ) as begin select Sal from Salary where Name=@name end exec [dbo].[Test] 'Your Name'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)