회원번호 가져오기

create function memNum(@mID varchar(20))
returns int
as
begin
declare @memNum int
set @memNum = (select sn from member where id = @mID)
return @memNum
end