实现效果:在表中插入数据时,响应触发器在另外一个表插入数据
SQL命令
insert into myReport(Id,myName,myNum)values('40','小麦','20')
SQL触发器
create trigger [InsertDataNow]
on [dbo].[myReport]
for insert
as
begin
declare @myID as int
select @myID = ID from inserted
insert into bb(aa)values(@myID)
end
实现效果:创建存储过程 create procedure myReportInsert @Id int, @myName varchar(50), @myNum int as insert into myReport(Id,myName,myNum)values(@Id,@myName,@myNum) go 执行存储过程 exec myReportInsert '45','桔子',50
posted on 2010-05-03 12:03 阅读(56)