27,579
社区成员
发帖
与我相关
我的任务
分享
create trigger list2listb
on list
for insert
as
begin
insert into list_B select code,ltrim(code)+right('00'+ltrim(Num),2) from inserted
end
create trigger list2listb
on list
for insert
as
begin
insert into list_B select ltrim(code)+right('00'+ltrim(Num),2),Name from inserted
end