SCOPE_IDENTITY()

SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY];
GO 

https://msdn.microsoft.com/en-us/library/ms190315.aspx


SELECT @Variable = SCOPE_IDENTITY()