*******$B!ZCm0U![(B*********
$B$3$N%a!<%k$O!"4IM}<T$K$h$C$F!"J8;z%3!<%I$,=q$-49$($i$l$^$7$?!#(B
$B85$N%*%j%8%J%k%a!<%k$O!"%7%U%H(BJIS$B%3!<%I$G$7$?!#(B
Content-Type: text/plain;charset="shift_jis"
**********************




$BBgJQ;29M$K$J$j$^$7$?!#(B
$B$"$j$,$H$&$4$6$$$^$7$?!#(B
$B$*$=$i$/$O!"%H%j%,$r;HMQ$9$k$s$@$m$&$J(B
$B;W$C$F$$$^$7$?$,!"$3$l$G$O$C$-$j$7$^$7$?!#(B




-----Original Message-----
From: Akihiro Tsutsui [mailto:who@example.ne.jp] 
Sent: Sunday, July 13, 2003 11:36 AM
To: who@example.ne.jp
Subject: [ml-msde-beg:00706] Re: $B%j%l!<%7%g%s$"$k%U%#!<%k%I99?7(B


$B=i$a$^$7$F!"E{0f$H?=$7$^$9!#(B
$B$?$^$?$^!"EvJ}$b;w$?$h$&$J:n6H$r@h=5Kv$K$d$j$^$7$?$N$G(B
$B;29M$K$J$k$+$I$&$+H=$j$^$;$s$,!&!&!&(B

$B%F!<%V%k(B1$B$H%F!<%V%k(B2$B$N9=B$$,!J@55,2=$H$$$&E@$G!K$I$&$J$C$F$$$k$N$+(B
$B$h$/$o$+$j$^$;$s$,!"%F!<%V%k(B1$B$O=P2Y@h%^%9%?E*$J$b$N!"%F!<%V%k(B2$B$O(B
$B=P2Y5-O?E*$J$b$N!"(Bid1$B$H(Bid2$B$OF1$8CM$G$"$j!"%F!<%V%k(B1$B$H%F!<%V%k(B2$B$O(B
1$BBPB?$N4X78$G!"%F!<%V%k(B1$B$N(Bid$B$rJQ99$7$?$H$-$K%F!<%V%k(B2$B$N(Bid$B$bJQ99$7$?$$(B
$B!JO":?99?7!K$H$N$3$H$@$H2>Dj$7$F$NFbMF$G$9!#(B

$B4V0c$C$F$$$?$i?=$7Lu$J$$$N$G$9$,!"%H%j%,$rMxMQ$9$l$PG!2?$G$7$g$&!#(B
Access adp $B!J%"%/%;%9%W%m%8%'%/%H!K$r$*;H$$$G$7$?$i!"%F!<%V%kI=<((B
$B%&%$%s%I%&$G%H%j%,$r;E9~$_$?$$%F!<%V%k!JB?J,$3$N>l9g$@$H%F!<%V%k(B1$B!K(B
$B$r1&%/%j%C%/$7!"%H%j%,$rA*Br$9$k$H(BTSQL$B$r5-=R$9$k%&%#%s%I%&$,(B
$BI=<($5$l$^$9$N$G!"$=$3$K0J2<$N%3!<%I$r5-=R$7$F$_$F$/$@$5$$!#(B

Create trriga dbo.$B%F!<%V%k(B1id_$B99?7(B On $B%F!<%V%k(B1
for Update
as

$B!!(Bdeclare @newid int, @oldid int

$B!!!!(Bset @newid = ( select from inserted )
$B!!!!(Bset @oldid = ( select from deleted )

$B!!!!(Bset nocount on

$B!!!!!!(Bif update ( id1 )
$B!!!!!!!!(Bbegin
$B!!!!!!!!!!(Bupdate $B%F!<%V%k(B2 set id2 = @newid from $B%F!<%V%k(B
2,inserted,deleted where $B%F!<%V%k(B2.id2 = @oldid
$B!!!!!!!!(Bend
$B!!!!!!(Breturn


$B>e5-%3!<%I$N:G=i(B2$B9T(B Create $B$+$i(B as $B$^$G$O!"%9%Z%j%s%0$,4V0c$C$F$$$k(B
$B2DG=@-$,Hs>o$K9b$$$N$G%H%j%,:n@.2hLL$KI=<($5$l$k%9%Z%j%s%0$K(B
$B$"$o$;$F$/$@$5$$!#(B
$B8=:_!"<+Bp$J$N$GF0:n3NG'$,$G$-$J$$$?$a!"%(%(2C8:$JJV?.$K$J$j(B
$B?=$7Lu$4$6$$$^$;$s!#(B

$B$^$?EvJ}$b;O$a$F?t%v7n$N%S%.%J!<$N$?$a!"4V0c$$!"9M$(0c$$$J$I(B
$B$4$6$$$^$7$?$i!"<1<T$NJ}$N$4;XE&$r$*BT$A$7$?$$$H;W$$$^$9!#(B




>Access2002$B$H(BMSDE$B$G4JC1$J%"%W%j%1!<%7%g%s$r(B
>$B:n$m$&$H$7$F$*$j$^$9$,!"(Bmdb$B$N463P$,$I$&$7$F$b(B
>$BH4$1$:!"$I$&$b$&$^$/$$$-$^$;$s!#(B
>$B$I$J$?$+$465<x$*4j$$$7$^$9!#(B
>
>$B$d$j$?$$$3$H$O0J2<$NDL$j$G$9!#(B
>2$B$D$N%F!<%V%k#1$H#2$,$"$j$^$9!#(B
>id$B$G%j%l!<%7%g%s$7$F$$$^$9!#(B
>id1,$B=P2Y@h!"F|IU!"%3!<%I!"IJL>!"?tNL(B
>$B$N%U%#!<%k%I$G%S%e!<I=$r:n$j!"(B
>id1$B$,99?7$5$l$k$H!"(Bid2$B$K$bF1$8CM$,(B
>$BF~NO$5$l$k$H$$$&$b$N$G$9!#(B
>
>
>
>$B%F!<%V%k#1(B
>id1	int(identity)	$B%-!<(B
>$B=P2Y@h(B	varchar
>$BF|IU(B	datetime	
>
>
>
>$B%F!<%V%k#2(B
>id2	int		$B%-!<(B
>$B%3!<%I(B	varchar		$B%-!<(B
>$BIJL>(B	varchar
>$B?tNL(B	int
***************
Akihiro Tsutsui
***************