RE: [Programmer-VB] Mendapatkan Nilai Inputan di Triggers SqlServer

Mon, 17 Apr 2006 22:22:04 -0700

...

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 J

 

Contoh cara re-Execute : Insert into Table_A select * from Inserted

 

Selamat mencoba J

 

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&cent;/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



Kirim email ke