>USE tempdb >GO >CREATE TABLE T1 ( > Z_id int IDENTITY(1,1)PRIMARY KEY, > Z_name varchar(20) NOT NULL) > >INSERT T1 > VALUES ('Lisa') >INSERT T1 > VALUES ('Mike') >INSERT T1 > VALUES ('Carla') > >CREATE TABLE T2 ( > Y_id int IDENTITY(100,5)PRIMARY KEY, > Y_name varchar(20) NULL) > >INSERT T2 (Y_name) > VALUES ('boathouse') >INSERT T2 (Y_name) > VALUES ('rocks') >INSERT T2 (Y_name) > VALUES ('elevator') > >CREATE TRIGGER T1_trig >ON T1 >FOR INSERT AS > BEGIN > INSERT T2 VALUES ('') > END >>
>oCA.InsertCmdRefreshFieldList = "z_id" oCA.InsertCmdRefreshCmd="SELECT SCOPE_IDENTITY()" >>