create proc CheckLogIn ( @Username varchar(50), @Password varchar(50), @Error tinyint output ) as if (select COUNT(*) from FinalFantasyInfo.dbo.MainStaffInfo where UID = @Username and Password = @Password) = '1' set @Error = '0' else set @Error = '1'