触发器代码
create trigger tril on student
after insert
as
begin
declare @str char(20)
set @str = 'Trigger is working'
end
插入时代码
insert into student values('20101023','曹恩齐','男','19','软件工程')
结果
显示不出来这个trigger is working
触发器代码
create trigger tril on student
after insert
as
begin
declare @str char(20)
set @str = 'Trigger is working'
end
插入时代码
insert into student values('20101023','曹恩齐','男','19','软件工程')
结果
显示不出来这个trigger is working
你想显示这东西,那就得执行select 'Trigger is working'
否则你只定义了一个变量,又没有任何语句去打印这个变量