청강컴정/09DataBase중간고사
카페 가입여부 체크
luckey
2009. 4. 17. 13:32
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
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