DECLARE @ID INT


INSERT INTO TableName (Columns1, Column2) 
VALUES(Value1, Value2)

SET @ID = @@IDENTITY

-查看最后插入的身份值
选择@ID AS [身份]

身份 [

--View Last inserted identity Value
SELECT @ID AS [Identity]

IDENTITY[^]