trigger question

[griffitd]

Hi

I have the following code in an update trigger

ALTER Trigger [dbo].[Upd_TIIssueQty]
On [dbo].[TrimIssued] FOR UPDATE NOT FOR REPLICATION
AS
Declare @MyAddQty decimal(10,2)
Declare @MyBOMItemCode int
Declare @MyWorkareaCode int
Declare @MyStyleCode int
Declare @MyPackCode int
Declare @MyGarmCode int
Declare @MySizeCode int
Declare @MyLocation varchar(20)
Declare @MyNewIssueQty decimal(10,2)
Declare @MyNewIssueRetQty decimal(10,2)

Declare @MyOldIssueQty decimal(10,2)
Declare @MyOldIssueRetQty decimal(10,2)

Declare @MyRowCount int

SELECT @MyRowCount=COUNT(*) FROM INSERTED

what will @Myrowcount be when an update occurs? does the from inserted use the updated records

Thanks in advance

 

[danvlas]

You will get the number of updated records.

INSERTED will contain the new values
DELETED will contain the old values

Both will have the same number of records.



Daniel Vlas
Systems Consultant

 

[markros]

Check also this link to avoid some common misconceptions when writing a trigger

http://blogs.lessthandot.com/index....rver/best-practice-coding-sql-server-triggers

PluralSight Learning Library