2018”N08ŒŽ08“ú

•½¬‚R‚O”N“xtŠú Šî–{î•ñ‹ZpŽÒŽŽŒ±–â‘è –â‚Q‚W

–â‚Q‚W
–„ž‚Ý‚r‚p‚k‚ð—p‚¢‚½ƒvƒƒOƒ‰ƒ€‚̈ꕔ‚É‚¨‚¢‚āA
‚w‚͉½‚ð•\‚·–¼‘O‚©B

EXEC SQL OPEN X;
@@EXEC SQL FETCH X INTO :NAME, :DEPT, :SALARY;
@@EXEC SQL UPDATE ]‹Æˆõ
@@@@SET ‹‹—^ = ‹‹—^ * 1.1
@@@@WHERE CURRENT OF X;
EXEC SQL CLOSE X;

@ƒA@ƒJ[ƒ\ƒ‹
@ƒC@ƒXƒL[ƒ}
@ƒE@ƒe[ƒuƒ‹
@ƒG@ƒrƒ…[



y³‰ðz@ƒA

–„‚ߍž‚Ý‚r‚p‚k‚́A‚bŒ¾Œê‚Ȃǂ̎葱‚«Œ^ƒvƒƒOƒ‰ƒ~ƒ“ƒO‚É‚¨‚¢‚āARDBMS‚𑀍ì
‚·‚邽‚ß‚É‚r‚p‚k‚ð‘g‚ݍž‚ÞŽè–@‚Ì‚±‚Æ‚Å‚ ‚éB

ƒA@FETCH ‚Å‚Ps‚¸‚‘€ì‚·‚é‚̂́AƒJ[ƒ\ƒ‹‚Å‚ ‚éB
@CURRENT ‚àƒJ[ƒ\ƒ‹‚𑀍삷‚鎞‚ÉŽg—p‚·‚éŒê‹å‚Å‚ ‚éB
ƒG@ƒrƒ…[‚ɑ΂µ‚Ă͍XV‚Å‚«‚È‚¢B

EXCEL ‚u‚a‚`‚Ì‚²‘Š’k‚È‚ç@ ƒtƒ@[ƒXƒgƒ}ƒNƒ @‚Ö



posted by ƒtƒ@[ƒXƒgƒ}ƒNƒ at 20:40| Comment(0) | H30tŠî–{î•ñ‹ZpŽÒ
‚±‚Ì‹LŽ–‚ւ̃Rƒƒ“ƒg
ƒRƒƒ“ƒg‚ð‘‚­
‚¨–¼‘O:

ƒ[ƒ‹ƒAƒhƒŒƒX:

ƒz[ƒ€ƒy[ƒWƒAƒhƒŒƒX:

ƒRƒƒ“ƒg: