USE [KPMIS]
GO
/****** 对象: Trigger [dbo].[Bas_Bulletin_insert_trigger] 脚本日期: 11/15/2010 14:00:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Bas_Bulletin_insert_trigger] ON [dbo].[Bas_Bulletin] FOR INSERT AS
UPDATE [side] SET [sync_row_is_tombstone] = 0, [local_update_peer_key] = 0, [restore_timestamp] = NULL, [update_scope_local_id] = NULL, [last_change_datetime] = GETDATE() FROM [Bas_Bulletin_tracking] [side] JOIN INSERTED AS [i] ON [side].[Bul_ID] = [i].[Bul_ID]
INSERT INTO [Bas_Bulletin_tracking] ([i].[Bul_ID], [create_scope_local_id], [local_create_peer_key], [local_create_peer_timestamp], [update_scope_local_id], [local_update_peer_key], [sync_row_is_tombstone], [last_change_datetime], [restore_timestamp]) SELECT [i].[Bul_ID], NULL, 0, @@DBTS+1, NULL, 0, 0, GETDATE() , NULL FROM INSERTED AS [i] LEFT JOIN [Bas_Bulletin_tracking] [side] ON [side].[Bul_ID] = [i].[Bul_ID] WHERE [side].[Bul_ID] IS NULL