方法一:Select @@IDENTITY 方法二:Select IDENT_CURRENT('TEST') 方法三:Select SCOPE_IDENTITY() 转载于:https://www.cnblogs.com/hanwater/archive/2010/11/26/1888837.html