可否详细点我比较苯,我要是有一个表PRO_COD触发器为:
REATE TRIGGER PRO_COD_INS ON dbo.pro_cod
FOR INSERT
AS
DECLARE @NUMMIN INT
DECLARE @NUMMAX INT
DECLARE @NUMSUP INT
DECLARE @UQI INT
DECLARE @PRI DECIMAL(18,6)
DECLARE @PRIuni DECIMAL(18,6)
DECLARE @UQIDEP INT
DECLARE @I INT
SELECT @NUMSUP =(SELECT MIN(UQI) FROM PRD_COD WHERE FLA_SUP='Y')
SELECT @NUMMIN=(SELECT MIN(UQI) FROM DEP_COD WHERE CAT_DEP='PER' OR CAT_DEP='UNI' OR CAT_DEP='STO')
SELECT @NUMMAX=(SELECT MAX(UQI) FROM DEP_COD WHERE CAT_DEP='PER' OR CAT_DEP='UNI' OR CAT_DEP='STO')
SELECT @PRI=(SELECT PRI_PER FROM INSERTED)
SELECT @PRIuni=(SELECT PRI_uni FROM INSERTED)
SELECT @UQI=(SELECT UQI FROM INSERTED)
SELECT @I = @NUMMIN-100 WHILE @I >= @NUMMIN-100
BEGIN
SELECT @I = @I+100
SELECT @UQIDEP=(SELECT UQI FROM DEP_COD WHERE UQI=@I) IF @I>@NUMMAX BREAK ELSE
IF @UQIDEP IS NOT NULL
BEGIN
INSERT INTO PRO_STO
VALUES (@I,@UQI,'',NULL,NULL,0,0,0,0,0,0,0,0,0,0,GETDATE(),NULL,NULL,'','',0,0,0,0,0,0,0,0,0,0,0,0,0,1,@PRI,'AAA')
INSERT INTO PRO_SLL_ANA
VALUES (@I,@UQI,@NUMSUP,0,0,0,0,0,0,0,0,0,0)
END
END