创建立触发器 create table A( A1 int )create table B( B1 int ) create trigger tri_A on A for insert as declare @Avalue int select @Avalue=A1 from inserted insert into B values(@Avalue/2) goinsert into A values(8)
Update B set B1 = (SELECT A1*2 FROM A WHERE ID = B.ID ) ID为A表,B表的关联列。
不好意思,我没说清楚。 一、如果B表是空,并且只有一列B1: INSERT INTO B SELECT A1*2 FROM A二、如果B表已经有数据,只是B1 列需要填充,那么A表和B表肯定有某些关系,不然无法填充。 UPDATE B SET B1 = (SELECT A1*2 FROM A WHERE ID = B.ID )
--计算列 create table tb (a int,b as a*2) insert into tb select 1 insert into tb select 2 insert into tb select 3 select * from tb
A1 int
)create table B(
B1 int
)
create trigger tri_A
on A
for insert
as
declare @Avalue int
select @Avalue=A1 from inserted
insert into B values(@Avalue/2)
goinsert into A values(8)
ID为A表,B表的关联列。
一、如果B表是空,并且只有一列B1:
INSERT INTO B SELECT A1*2 FROM A二、如果B表已经有数据,只是B1 列需要填充,那么A表和B表肯定有某些关系,不然无法填充。
UPDATE B SET B1 = (SELECT A1*2 FROM A WHERE ID = B.ID )
create table tb (a int,b as a*2)
insert into tb select 1
insert into tb select 2
insert into tb select 3
select * from tb