How do I amend this trigger ?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mkumari Hall of Fame Points: 3498 More actions · Answer 1

Hope this works for you.

CREATE TRIGGER TR_InsertUpdate1 ON dbo.tblAddress

FOR INSERT, UPDATE

AS

DECLARE @CN VARCHAR(50), @ID INT

SELECT @CN = Company_Name, @ID = address_id FROM Inserted

IF @CN = 'UNIVERSITY'

BEGIN

UPDATE tblAddress SET

Column = 'TRUE'

WHERE address_ID = @ID

END

Mkumari Hall of Fame Points: 3498 More actions · Answer 2

Can you please send the reply's to the form in the future.

shendricks SSChasing Mays Points: 635 More actions · Answer 3

MKumari,

Your solution assumes that only one record has been inserted/updated.

create trigger TR_InsertUpdate1 on dbo.tblAddress

for insert, update

as

begin

update dbo.tblAddress

set education = 'True'

from dbo.tblAddress a

join inserted i on i.Primary = a.Primary

where i.Company_Name = 'UNIVERSITY'

-- i.Company_Name like '%UNIVERSITY%'

-- (if you prefer)

end

Steve Hendricks

MCSD, MCDBA

AFS Consulting Group

(949) 588-9800 x15

Steve Hendricks
MCSD, MCDBA
Data Matrix

shendricks@afsconsulting.com
(949) 588-9800 x15

Mkumari Hall of Fame Points: 3498 More actions · Answer 4

shendricks,put this into a cursor,if you want to do the bulk insert/update and want to fire the trigger.

Cookies on SQLServerCentral