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

Mon, 17 Apr 2006 21:45:51 -0700

CMIIW...
 
Create Trigger InsertA1 On A1
FOR INSERT
as
begin
 IF EXIST(SELECT * FROM Table_A WHERE A1='1111')
 
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

Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.

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



SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



Kirim email ke