Trigger

SCHICHTGRUPPEN_INS

Beschreibung

Trigger um den Primary Key zu setzen.

Definition

CREATE TRIGGER SCHICHTGRUPPEN_INS FOR SCHICHTGRUPPEN
ACTIVE BEFORE INSERT POSITION 0
AS 
BEGIN 
  IF (NEW.SGID IS NULL) THEN 
     NEW.SGID = GEN_ID(SGID_GEN, 2);
END