Hi All,
In My Table , I have Three Column like Qty,Price and Total, I create a Trigger for this .
Table:
CREATE TABLE [dbo].[tbl_SO]([SoNo] [varchar](50) NULL,
[Qty] [int] NULL,
[price] [numeric](18, 2) NULL,
[total] [numeric](18, 2) NULL
) ON [PRIMARY]
Trigger:
CREATETRIGGER trgAfterUpdateEMGSO on DB1.DBO.TBL_SOFOR UPDATE
AS
ALTER TABLE DB2.DBO.TBL_SO DISABLE TRIGGER TrgAfterUpdateSO
UPDATE DB2.dbo.TBL_SO
SET SONO = i.SONO,
Qty=I.QTY,
price=I.price,
total = I.Qty*I.Price
FROM Inserted i
INNER JOIN DB2.dbo.TBL_SO tb2 ON tb2.SoNo = i.SONo
ALTER TABLE DB2.DBO.TBL_SO ENABLE TRIGGER TrgAfterUpdateSO
Input :
1) UPDATE TBL_SO SET QTY='10',Price='100' Where SONo='10'
2)UPDATE TBL_SO SET QTY='10',Price='100' Total=Qty*Price Where SONo='10'
Output:
What I get?
I tried both 1 and 2, It(Query) does not work on first time,I executed (Query) second time It works.Why?
What I need?
How to work on First Time?
Please let me know your comments and Feed back
- Changed type Katherine XiongMicrosoft contingent staff, Moderator Tuesday, April 21, 2015 5:56 AM it is a question