文件名称:SQLSERVER触发器插入数据
文件大小:1KB
文件格式:TXT
更新时间:2012-12-23 10:53:58
SQLSERVER 触发器
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
文件名称:SQLSERVER触发器插入数据
文件大小:1KB
文件格式:TXT
更新时间:2012-12-23 10:53:58
SQLSERVER 触发器
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