create trigger tr_sys_jtBMIns on sys_jtBM for insert as declare @id varchar(3),@cmpname varchar(50),@str varchar(8000) select @id=id,@cmpname=cmpname from inserted --由表sys_employee_breif_mod派生 set @str='select * into' +@cmpname+'_employee_breif from sys_employee_breif_mod where 1<>1' exec(@str) --由表sys_employee_detail_mod派生 set @str='select * into' +@cmpname+'_employee_detail_mod from sys_employee_detail_mod where 1<>1' exec(@str) --由sys_dept_mod派生 set @str='select * into' +@cmpname+'_dept_mod from sys_dept_mod where 1<>1' exec(@str) --记录用户 insert into sys_userAccount(username) values(@cmpname+'manage')
for insert
as
declare @id varchar(3),@cmpname varchar(50),@str varchar(8000)
select @id=id,@cmpname=cmpname from inserted
--由表sys_employee_breif_mod派生
set @str='select * into' +@cmpname+'_employee_breif from sys_employee_breif_mod where 1<>1'
exec(@str)
--由表sys_employee_detail_mod派生
set @str='select * into' +@cmpname+'_employee_detail_mod from sys_employee_detail_mod where 1<>1'
exec(@str)
--由sys_dept_mod派生
set @str='select * into' +@cmpname+'_dept_mod from sys_dept_mod where 1<>1'
exec(@str)
--记录用户
insert into sys_userAccount(username)
values(@cmpname+'manage')