Pages

Banner 468 x 60px

 

Saturday, November 18, 2017

Trigger in SQL

0 comments
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

0 comments:

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH