sqlserver 存储过程

create procedure gppass_pro2
@paramYear varchar , @paramplanID int , @parampersonID int
as
declare @score int
declare myCursor cursor for
select st.testGrade from score_traingrade st
left join gp_tackinplan gxp on gxp.tackinPlanID = st.tackinPlanID
where st.tackinPlanID = @paramplanID and year(st.testdate) = @paramYear and personID = @parampersonID

open myCursor
fetch next from myCursor into @score
while (@@fetch_status=0)
begin
if(@score <60)
return 1

fetch next from myCursor into @score
end

close myCursor
deallocate myCursor
GO

declare @result int
exec @result = gppass_pro2 '2009' ,58 ,310700

select @result