select * from a2;
select * from ae;


create table ae (name varchar(20),id int,dates datetime,actions varchar(80));

create trigger upt on a2
for insert as
declare @id int;
declare @date datetime;
declare @name varchar(20),@action varchar(20);
select @id=i.id from inserted i
select @name=i.name from inserted i
Select @action='record inserted'
insert into ae values(@name,@id,getdate(),@action)
print'after triger executed'

create table a2(name varchar(20),id int);
insert into a2 values('irauw',63);

create trigger dellk on a2
for delete as
declare @id int;
declare @date datetime;
declare @name varchar(20),@action varchar(20);
select @id=i.id from deleted i
select @name=i.name from deleted i
Select @action='record deleted'
delete from ae where id in(@name,@id,getdate(),@action)
print'after triger executed'

delete from a2 where id=36

create trigger upais on a2
for update as
declare @id int;
declare @date datetime;
declare @name varchar(20),@action varchar(20);
select @id=i.id from updated i
select @name=i.name from updated i
Select @action='record updated'
update ae set id=35 where id=@id
print'after triger executed'

update ae set id=36 where id=35