实现效果：在表中插入数据时，响应触发器在另外一个表插入数据
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
