Date: Thu, 7 Mar 2002 22:18:37 +0900
From: "Hironari Tsujimoto" <who@sub.example.jp>
=1B$BF#:j$5$s!"$"$j$,$H$&$4$6$$$^$9!#=1B(B
=1B$B2r7h$7$^$7$?!#=1B(B
=1B$B$3$s$J$K4JC1$K$G$-$k$b$N$J$s$G$9$M!#L\$+$iNZ$G$9!#=1B(B
=1B$B$d$d$3$7$/9M$($9$.$F$^$7$?!#=1B(B
=1B$BF0E*$KJ8;zNs$r:n@.$7$F=1B(BADO=1B$B$G=1B(BExecute=1B$B$7$h$&$H$7$F$^=
$7$?$N$G=1B(B
=1B$B%/%i%$%"%s%H%5%$%I$N%W%m%0%i%`$N$"$A$3$A$K=1B(B
=1B$B$d$d$3$7$$%3!<%I=3Dq$/A0$@$C$?$N$GHs>o$K=3Du$+$j$^$7$?!#=1B(B
=1B$B0l1~0J2<$N$G@.8y$7$^$7$?$N$GNc$r:\$;$H$-$^$9!#=1B(B
------------------------------------------
ALTER PROCEDURE sp_=1B$BO"Mm@h=1B(Bget
(@=1B$BO"Mm@h=1B(BID int,
@=1B$B@A5a@h=1B(BID int,
@=1B$BC4Ev<R0w=1B(BID int)
AS SELECT =1B$BO"Mm@h=1B(BID, =1B$B@A5a@h=1B(BID, =
=1B$BC4Ev<R0w=1B(BID, =1B$B@5<0L>=1B(B
FROM M_=1B$B8\5R=1B(B
WHERE (=1B$BO"Mm@h=1B(BID =3D @=1B$BO"Mm@h=1B(BID OR =
@=1B$BO"Mm@h=1B(BID IS NULL) AND=20
(=1B$B@A5a@h=1B(BID =3D @=1B$B@A5a@h=1B(BID OR =
@=1B$B@A5a@h=1B(BID IS NULL) AND
(=1B$BC4Ev<R0w=1B(BID =3D @=1B$BC4Ev<R0w=1B(BID OR =
@=1B$BC4Ev<R0w=1B(BID IS NULL)
RETURN=20
------------------------------------------
=1B$BDT85=1B(B
| [MSDE/SQLServerに関して、今、どんなことにお困りですか？] |
| よろしければお困りの内容を、電子メールで教えて下さい。 |
|
質問を電子メールで作成する
|
[ウィンドを閉じる][MSDE/SQLServer FAQ ][MSDE / MSDE2000 技術サポート情報一覧]
|
