create or alter Trigger Trigger_name .... as begin 业务逻辑。 end
CREATE TRIGGER InsteadTrigger on InsteadView INSTEAD OF INSERT AS BEGIN INSERT INTO TableName SELECT Color, Material FROM inserted END GO
create trigger trg_insert on tableA for insert as begin begin transaction /*启用事务*/ insert into tableB(列名列表) select 列名列表 from inserted /*向B表插入*/ if @@error <> 0 /*如果向B表插入不成功*/ begin raiserror('抱歉,插入失败!',16,1) /*抛出异常*/ rollback /*事务回滚*/ end else commit /*如果插入成功则提交事务*/ end GO
create table A (id int,name varchar(100)) go create table B (日期 datetime,id int,数量 int) go---创建触发器 create trigger tr_insert on [dbo].[a] for insert as insert into b(日期,id) select getdate(),id from inserted go insert into A(ID,name) select 2,'b'select * from A select * from Bdrop table A,B
after insert
as
begin
业务逻辑。
end
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO TableName
SELECT Color, Material
FROM inserted
END
GO
for insert
as
begin
begin transaction /*启用事务*/
insert into tableB(列名列表) select 列名列表 from inserted /*向B表插入*/
if @@error <> 0 /*如果向B表插入不成功*/
begin
raiserror('抱歉,插入失败!',16,1) /*抛出异常*/
rollback /*事务回滚*/
end
else
commit /*如果插入成功则提交事务*/
end
GO
create table A (id int,name varchar(100))
go
create table B (日期 datetime,id int,数量 int)
go---创建触发器
create trigger tr_insert on [dbo].[a]
for insert
as
insert into b(日期,id) select getdate(),id from inserted
go
insert into A(ID,name) select 2,'b'select * from A
select * from Bdrop table A,B