- Beranda
- Komunitas
- Tech
- Programmer Forum
[ask] sql server
![prorief](https://s.kaskus.id/user/avatar/2010/07/05/avatar1845167_14.gif)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
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![Malu (S) emoticon-Malu (S)](https://s.kaskus.id/images/smilies/malus.gif)
buat yang bantu jawan ane doain dah tambah ganteng n tambah rejeki![Malu (S) emoticon-Malu (S)](https://s.kaskus.id/images/smilies/malus.gif)
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
![Malu (S) emoticon-Malu (S)](https://s.kaskus.id/images/smilies/malus.gif)
buat yang bantu jawan ane doain dah tambah ganteng n tambah rejeki
![Malu (S) emoticon-Malu (S)](https://s.kaskus.id/images/smilies/malus.gif)
0
666
3
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Urutan
Terbaru
Terlama
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Komunitas Pilihan