SQLSERVER触发器插入数据

Assembly code

CREATE table TSYS_BAMKZ(id int identity(1,1),MKZM nvarchar(20),PARENT int)

CREATE table TSYS_MKZ(id int identity(1,1),MKZM nvarchar(20),yhz nvarchar(20),PARENT int)
insert TSYS_MKZ
SELECT '部门1','管理员','10' union all
SELECT '部门2','仓管员','20' union all
SELECT '部门3','生产管理','30'


CREATE TRIGGER TT ON TSYS_BAMKZ
FOR INSERT
AS
INSERT TSYS_MKZ
SELECT B.MKZM,A.yhz,B.PARENT
FROM (SELECT DISTINCT yhz FROM TSYS_MKZ) A,INSERTED B

insert TSYS_BAMKZ 
SELECT '部门名称',50

----------------------------------------------------------------------
SELECT  FROM TSYS_MKZ

id          MKZM                 yhz                  PARENT
----------- -------------------- -------------------- -----------
1           部门1               管理员                  10
2           部门2               仓管员                  20
3           部门3               生产管理                30
4           部门名称          仓管员                  50