Pages

Saturday, November 18, 2017

Trigger in SQL

Trigger in SQL :

USE [MicrosoftDynamicsAX]
GO
/****** Object:  Trigger [dbo].[test]    Script Date: 6/14/2016 3:33:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Trigger [dbo].[test]
ON [dbo].[Table_1]
For insert
AS

INSERT INTO DB_Staging.dbo.Table_1


SELECT * FROM inserted

No comments:

Post a Comment

Give me feedback.