[ASK] Inisialisasi Trigger (Ms SQL 2000)
 

nanya gan, gimana sih cara membuat inisialisasi tambahan sebelum di trigger dilakukan?



yg ane buat kok gak bisa baca inserted nya ya?




Code:

CREATE TRIGGER TriggerKu ON TabelA FOR UPDATE AS
DECLARE @i numeric
DECLARE @count varchar(300)
BEGIN
SET @count = 'SELECT COUNT(B.angsuran_ke) FROM TableB B, inserted ins
WHERE B.kode_pinjaman = ins.kode_pinjaman'
EXECUTE(@count)
SET @i = 1

WHILE NOT @i = CAST(@count as numeric)
BEGIN
/* looping angsuran ke 1 s/d @count */
SET @i = @i + 1
END
END

pesan error:


Code:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'inserted'.

mohon bimbingan nya agan2 yg baik..... :ceriwislove:

</div>