测试@@IDENTITY,SCOPE_IDENTITY,IDENT_CURRENT的区别 在网上看了看,什么域啊域的,不好理解,不如自己实测一下,理解得好 Code--创建表1CREATE TABLE TABLE_a( ID INT IDENTITY PRIMARY KEY, COL1 VARCHAR(100))--创建表2并插入数据(目的:使两个表当前最大ID不相同)CREATE TABLE TABLE_b( ID INT IDENTITY PRIMARY KEY, COL1 VARCHAR(100))INSERT INTO TABLE_b SELECT 'ZENGJIA'INSERT INTO TABLE_b SELECT 'ZENGJIA'INSERT INTO TABLE_b SELECT 'ZENGJIA'--在表1上创建触发器CREATE TRIGGER UPDATE_tb ON TABLE_a AFTER INSERTASINSERT INTO TABLE_b SELECT 'ASDF' --往表1插入数据INSERT INTO TABLE_a SELECT 'TEST1'SELECT @@IDENTITYSELECT SCOPE_IDENTITY()SELECT IDENT_CURRENT('TABLE_a')SELECT IDENT_CURRENT('TABLE_B')--结果: 结论: IDENT_CURRENT最保险,只要指定了表名一般不会有问题 其次是scope_identity 最后用@@identity