neh contohnya... tapi ga dijamin bener, tapi kurang lebih logikanya pas deh (KAYAKNYA), he he he..., klo kira2 err di explore dulu aja ya.
create TRIGGER Trig_Insert_TabelX ON dbo.[TabelX]
FOR INSERT
AS
BEGIN
declare @Status varchar(20)
declare @JumlahRec int
declare @PK varchar(20)
declare @field1 varchar(20)
declare @field2 varchar(20)
SELECT
@PK=PK
@Status=Status
@field1=field1
@field2=field2
FROM inserted
if @Status='TRUE'
@Status=1
end
if @Status='FALSE'
@Status=0
end
BEGIN TRANSACTION
--KALO GA ADA DATA
select @JumlahRec=count(*)
from
dbo.TabelX
where
[EMAIL PROTECTED]
if @JumlahRec=0
begin
insert into dbo.TabelX
(PK, field1,
field2, Status)
select
(@PK, @field1,
@field2,@Status)
end
-- Kalo datanya ada
update dbo.TabelX
set [EMAIL PROTECTED]
where [EMAIL PROTECTED]
COMMIT TRANSACTION
END
--- In [email protected], Indra WS <[EMAIL PROTECTED]>
wrote:
>
> kk2 master VB, mo tanya ttg trigger di SQL donk.
> saya mau buat trigger, ketika insert atau update suatu
field(contoh: Status)
> dan jika nilainya itu adalah 'false' maka 0, dan 'true' maka 1.
>
> thanks.
> GBU
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with
Yahoo! Search.
>
