gan ane ada triger kaya gini

USE [databaseNoTelp]
GO
/****** Object: Trigger [dbo].[trigerJumlahKontak] Script Date: 01/17/2015 10:16:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[trigerJumlahKontak]
ON [dbo].[kontak]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for trigger here
update jumlahKontak set jumlah='666'

END


ane pengennya angka 666 tu diganti ama jumlah baris ada di tabel kontak

buat agan agan yang bisa master mungkin bisa bantu ane


buat yang bantu jawan ane doain dah tambah ganteng n tambah rejeki