hi
Create PROCEDURE CheckUserName
(
@name nvarchar(50), --Input parameter , Studentid of the student
@return int OUT -- Out parameter declared with the help of OUT keyword
)
AS
begin
declare @pid int;
set @pid=(select name from login where name=@name);
if(@pid=1)
begin
set @return=1
end
else
set @return=0
end
execute CheckUserName 'sankar'
while executing this its showing error like this
Msg 201, Level 16, State 4, Procedure CheckUserName, Line 0
Procedure or function 'CheckUserName' expects parameter '@return', which was not supplied.
sankarreddy