求个 sql 触发器!

[auqfiudh]

货款表(编号,货款地,登记人,登记时间)
员工表(编号,姓名,工作地,手机)


当 货款表 里插入数据时
就 修改表字段

货款表.货款地 =员工表.工作地

条件是

货款表.登记人=员工表.姓名
货款表.货款地 is null

[卖水果的net]

create table emp(eid int, addr varchar(10))
go
create table tra(tid int, eid int, addr varchar(10))
go
create trigger tra_ins 
on tra after insert 
as
begin
    update tra set tra.addr = emp.addr
    from tra , inserted , emp 
    where tra.eid = emp.eid and tra.tid = inserted.tid
end
go
insert into emp values(100,'ShangHai'),(200,'Hebei')
insert into tra(tid, eid) values(1,100)
go
select * from tra 
go
drop table tra , emp 
go


(1 行受影响)
tid         eid         addr
----------- ----------- ----------
1           100         ShangHai

(1 行受影响)

[auqfiudh]

引用 1 楼 wmxcn2000 的回复:

create table emp(eid int, addr varchar(10))
go
create table tra(tid int, eid int, addr varchar(10))
go
create trigger tra_ins 
on tra after insert 
as
begin
    update tra set tra.addr = emp.addr
    from tra , inserted , emp 
    where tra.eid = emp.eid and tra.tid = inserted.tid
end
go
insert into emp values(100,'ShangHai'),(200,'Hebei')
insert into tra(tid, eid) values(1,100)
go
select * from tra 
go
drop table tra , emp 
go


(1 行受影响)
tid         eid         addr
----------- ----------- ----------
1           100         ShangHai

(1 行受影响)

第10行的 inserted是做什么 用的?

[卖水果的net]

inserted 就是你刚写入的这条（或这些条）记录；