-- create the example tables
create table t_customer(id int, custname varchar(255))
create table t_customer_changed(id int, custname varchar(255))
-- create the trigger
create trigger t_customer_change_track
on t_customer
for update
as
begin
set nocount on
insert t_customer_changed
select * from deleted
set nocount off
end
-- create some testdata
insert t_customer(id, custname)
select 1, 'mike' union all
select 2, 'Fred'
-- show testdata
select * from t_customer
select * from t_customer_changed
-- do the update
update t_customer
set custname = 'Mike13' where id=1
-- show testdata
select * from t_customer
select * from t_customer_changed
Too old to Rock'n'Roll too young to die.
begginer Trigger question
Posted - 02/22/2013 : 06:16:00
