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
<*> 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/
