就是并发性问题
引用邹建的
-- 测试数据
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
IF OBJECT_ID('T2') IS NOT NULL
DROP TABLE T2
IF OBJECT_ID('T3') IS NOT NULL
DROP TABLE T3
CREATE TABLE T1(
id int IDENTITY, col int)
CREATE TABLE T2(
id int IDENTITY, col int)
CREATE TABLE T3(
t1_id int, t2_id int)
GO
-- 在t2上写个触发器, 传出数据
CREATE TRIGGER tr_T2_insert ON T2
FOR INSERT
AS
IF OBJECT_ID('tempdb..#') IS NOT NULL
INSERT # SELECT id FROM inserted
GO
-- 追加数据处理
DECLARE @t1_id int
IF OBJECT_ID('tempdb..#') IS NOT NULL
DROP TABLE #
CREATE TABLE #(id int)