use pubs
gocreate trigger tri_upd on sales
for insert, update
AS
update Northwind..Orders set CustomerID = 'HawaiiLeo' where OrderID=10248
gocreate trigger tri_upd on sales
for insert, update
AS
update Northwind..Orders set CustomerID = 'HawaiiLeo' where OrderID=10248
goif exists(select name from sysobjects where name='tri_upd' and xtype='TR')
drop trigger tri_updgo
create trigger tri_upd on sales
for update,insert
as
update Northwind..Region set RegionDescription = 'Leo' where RegionID = '1'