rianto isaac's Weblog

rianto utomo isaac sahala utomo

sql, trigger update

leave a comment »

CREATE TRIGGER [jurnal_update] ON [dbo].[aGL_Jurnal]
FOR UPDATE
AS
if (select flgpost from inserted) = 1
begin
RAISERROR (‘Cannot update this journal.’, 16, 1)
ROLLBACK TRAN
end

Written by isaaconi

Februari 7, 2011 pada 3:39 pm

Tinggalkan komentar