触发器, 更正huwgao(小楼听雨)的笔误create trigger test on 表1 for insert -------- as insert into 表2(…,字段,…) select …,字段,… from inserted
在表1中编写insert触发器。 语法上面说了。
hmily1688(刘胜涛--进军WAP) :够狠,不过说的有道理
create trigger test on 表1 for insert as insert into 表2(固定值字段1,固定值字段2...,固定值字段n,某字段) select '固定值1','固定值2'...,'固定值n',某字段 from inserted
不写代码好像不行的 用触发器吧 create trigger trig_test on table1 for insert as insert into table2(col1,col2....) select col1,col2... from inserted
To tx1icenhe(冒牌马可 V0.1) ,当然说得有道理啊。分给我吧。
用触发器,很简单的: create trigger test on table1 for insert as insert into table2(field1,field2...,固定值...,fieldn) select 'field1','field2'...,'固定值',fieldn from inserted
huwgao(小楼听雨) ( ) 信誉:100
的正确
更正huwgao(小楼听雨)的笔误create trigger test on 表1
for insert --------
as
insert into 表2(…,字段,…) select …,字段,… from inserted
语法上面说了。
for insert
as
insert into 表2(固定值字段1,固定值字段2...,固定值字段n,某字段)
select '固定值1','固定值2'...,'固定值n',某字段 from inserted
用触发器吧
create trigger trig_test on table1
for insert
as
insert into table2(col1,col2....)
select col1,col2... from inserted
create trigger test on table1
for insert
as
insert into table2(field1,field2...,固定值...,fieldn)
select 'field1','field2'...,'固定值',fieldn from inserted