Alienus Non diutius

create trigger TRG_MEMBER_INS on member instead of insert as begin set nocount on; begin tran begin try declare @GET_SN int declare @MIN_SN int declare @NEW_SN int declare @MAX_SN int select @GET_SN = sn from inserted if @GET_SN IS NULL OR exists(select * from member where sn = @GET_SN) begin select @MIN_SN = MIN(SN) from member select top 1 @NEW_SN = RN from ( select sn,(row_number() over (orde..

청강컴정/DataBase 2009. 5. 4. 17:26

declare @mID varchar(20) declare @cafeNum int declare @memNum int declare @cnt int declare @mChk bit set @cafeNum = 8 set @mID = 'mshong' set @memNum = cafe_manage.dbo.memNum(@mID) --1. 해당 카페의 회원인지 여부 확인 set @mChk = cafe_manage.dbo.memChk(@memNum, @cafeNum) --카페에 등록된 회원일 경우에만 업데이트를 실행한다. if(@mChk = 1) begin update Member_join set visit_count = visit_count + 1 where fk_member = @memNum and fk_caf..

청강컴정/09DataBase중간고사 2009. 4. 17. 13:33