表一的id添加出来后,再赋予表二就可以啦。
两句
sql="Select * from table1 order by id desc"
id=rs("id")
sql2="select * from table2 where id=100" '(这是根条件 比较是表二ID为100的)
或者
sql2="select * from table2 order by id desc '(这里是表二中最后一条记录)
rs("uid")=id ‘
rs.update
create trigger tr_customer1
on customer1 for insert
as
begin
declare @uid int
select @uid=uid from inserted
insert into customer2 (uid) values(@uid)
end
[Quote=引用 5 楼 lzp4881 的回复:]
create trigger tr_customer1
on customer1 for insert
as
begin
declare @uid int
select @uid=uid from inserted
insert into customer2 (uid) values(@uid)
end
[/Quote]
从业务逻辑和执行效率上,在触发器里写最合适.