你可以在分析器中写以下语句: CREATE TRIGGER Tri_copy ON [Talbe1] FOR INSERT,update AS declare @field1 varchar(20), @field2 datetime declare Cur_inserted cursor for{设置光标} select field1,field2 from inserted open Cur_inserted fetch next from Cur_inserted into @field1,@field2 WHILE @@FETCH_STATUS = 0 begin if ……{你的条件} begin insert into table2(field1,field2) values(@field1,@field2) end end close Cur_inserted deallocate Cur_inserted go
触发器一般有Insert,Update,Delete三种,本人水平有限,只介绍我常用的Insert触发器,我举个例子简要说明:此触发器用于表table中,id字段自动增加序号 Insert触发器: Create Trigger Trigger_Name On Table_Name for Insert As Declare @hi integer Select @hi=Max(id)+1 from table Where id<>0 if id=0 then @hi=id
CREATE TRIGGER Tri_copy ON [Talbe1]
FOR INSERT,update
AS
declare @field1 varchar(20),
@field2 datetime
declare Cur_inserted cursor for{设置光标}
select field1,field2 from inserted
open Cur_inserted
fetch next from Cur_inserted into @field1,@field2
WHILE @@FETCH_STATUS = 0
begin
if ……{你的条件}
begin
insert into table2(field1,field2)
values(@field1,@field2)
end
end
close Cur_inserted
deallocate Cur_inserted
go
Insert触发器:
Create Trigger Trigger_Name On Table_Name
for Insert
As
Declare @hi integer
Select @hi=Max(id)+1 from table Where id<>0
if id=0 then @hi=id