- Beranda
- Programmer Forum
[ask] sql server
...
TS
prorief
[ask] sql server
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
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
0
666
3
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.4KAnggota
Urutkan
Terlama
Komentar yang asik ya