create function memChk(@memNum int, @cafeNum int)
returns bit
begin
declare @returns bit
set @returns = 0
declare @cnt int
set @cnt = (select count(*) from member_join where fk_member = @memNum and fk_cafe = @cafeNum)
if(@cnt > 0)
begin
set @returns = 1
end
return @returns
end
댓글 영역