Terima Kasih ISmail Siregar --- Sistyo Alfan Tribowo <[EMAIL PROTECTED]> wrote:
> ... > > INSTEAD OF INSERT > as > begin > IF EXIST(SELECT * FROM Table_A WHERE A1=(SELECT A1 > FROM INSERTED)) > > ... > > > > KET: > > SQL Server menyediakan table system INSERTED (untuk > data baru) dan DELETED > (untuk data lama/update/delete). > > > > INSTEAD OF INSERT atau FOR INSERT?? > > > > FOR INSERT : Data langsung masuk ke tabel > > INSTEAD OF INSERT : data tidak masuk ke table, > kecuali kita re-Execute > command "INSERT INTO" di dalam Trigger. Trigger > model ini juga bisa > menyebabkan trigger lain dieksekusi walaupun nested > trigger didisable. See > SQL Server books Online :-) > > > > Contoh cara re-Execute : Insert into Table_A select > * from Inserted > > > > Selamat mencoba :-) > > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] > On Behalf Of ismail siregar > Sent: Tuesday, April 18, 2006 11:57 AM > To: [email protected]; > [EMAIL PROTECTED] > Subject: Re: [Programmer-VB] Mendapatkan Nilai > Inputan di Triggers SqlServer > > > > > > TERIMA KASIH SEBELUMNYA > > FOR INSERT > as > begin > IF EXIST(SELECT * FROM Table_A WHERE A1='1111') > > -> KALAU KAYAK GINI KAN BERARTI a1=KITA TENTUKAN, > MAKSUD SAYA NILAI YANG '1111' DI JADIKAN NILAI YG > AKAN > DI INSERT (YG AKAN DI MASUKKAN), SEMENTARA A1 NYA > ADALAH NILAI YANG TELAH TERSIMPAN, GIMANA CARANYA > YACH > ? > > end > > > ismail siregar <[EMAIL PROTECTED]> wrote: > > > > Rekan2 > > Bagaimana caranya untun Mendapatkan Nilai Inputan > > (Field) di Triggers SqlServer. > > > > Contohnya : > > > > Table A: > > Field A1 A2 > > 1111 XXXX > > 2222 yyyy > > > > Nah dari table diatas (A1) Sewaktu Di Insert > trigger > > kita dapat nilai yg akan nilai unting > dibandingkan. > > > > Create Trigger InsertA1 On A1 > > FOR INSERT > > as > > begin > > if <----------Gimana caranya untuk mengetahui > > field > > A1 Dengan nilai 1111 udah ada atau tidak > > end > > > > Terima kasih > > Ismail Siregar > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > > protection around > > http://mail.yahoo.com > > > > > > Wahana Programmer Groups Links > > > > > > > > > > > > > > > > SPONSORED LINKS > > Programmer Indonesia Basic programming > > language Computer programming languages > > Programming languages Java programming language > > > > --------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "Programmer-VB" on the web. > > > > To unsubscribe from this group, send an email > > to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of Service. > > > > > > --------------------------------- > > > > > > > > > > > > --------------------------------- > > Talk is cheap. Use Yahoo! Messenger to make > > PC-to-Phone calls. Great rates starting at > 1¢/min. > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > > Wahana Programmer Groups Links > > > > > > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "Programmer-VB > <http://groups.yahoo.com/group/Programmer-VB> " on > the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > * Your use of Yahoo! Groups is subject to the > Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of > Service. > > > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
