USE TEMPDB GO IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB IF OBJECT_ID('TB2') IS NOT NULL DROP TABLE TB2 GO CREATE TABLE TB(COL1 INT) CREATE TABLE TB2(ID INT IDENTITY(1,1),COL1 INT) GO CREATE TRIGGER TIG_TB_1 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+1 FROM INSERTED END GO CREATE TRIGGER TIG_TB_2 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+2 FROM INSERTED END GO CREATE TRIGGER TIG_TB_3 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+3 FROM INSERTED END GO INSERT INTO TB SELECT 1 GO SELECT * FROM TB2 /* 1 2 2 3 3 4 */
USE TEMPDB GO IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB IF OBJECT_ID('TB2') IS NOT NULL DROP TABLE TB2 GO CREATE TABLE TB(COL1 INT) CREATE TABLE TB2(ID INT IDENTITY(1,1),COL1 INT) GO CREATE TRIGGER TIG_TB_1 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+1 FROM INSERTED END GO CREATE TRIGGER TIG_TB_3 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+3 FROM INSERTED END GO CREATE TRIGGER TIG_TB_2 ON TB FOR INSERT AS BEGIN INSERT INTO TB2 SELECT COL1+2 FROM INSERTED END GO INSERT INTO TB SELECT 1 GO SELECT * FROM TB2 /* 1 2 2 4 3 3 */
GO
IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB
IF OBJECT_ID('TB2') IS NOT NULL DROP TABLE TB2
GO
CREATE TABLE TB(COL1 INT)
CREATE TABLE TB2(ID INT IDENTITY(1,1),COL1 INT)
GO
CREATE TRIGGER TIG_TB_1 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+1 FROM INSERTED
END
GO
CREATE TRIGGER TIG_TB_2 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+2 FROM INSERTED
END
GO
CREATE TRIGGER TIG_TB_3 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+3 FROM INSERTED
END
GO
INSERT INTO TB
SELECT 1
GO
SELECT * FROM TB2
/*
1 2
2 3
3 4
*/
GO
IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB
IF OBJECT_ID('TB2') IS NOT NULL DROP TABLE TB2
GO
CREATE TABLE TB(COL1 INT)
CREATE TABLE TB2(ID INT IDENTITY(1,1),COL1 INT)
GO
CREATE TRIGGER TIG_TB_1 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+1 FROM INSERTED
END
GO
CREATE TRIGGER TIG_TB_3 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+3 FROM INSERTED
END
GO
CREATE TRIGGER TIG_TB_2 ON TB
FOR INSERT
AS
BEGIN
INSERT INTO TB2
SELECT COL1+2 FROM INSERTED
END
GO
INSERT INTO TB
SELECT 1
GO
SELECT * FROM TB2
/*
1 2
2 4
3 3
*/