SELECT SCOPE_IDENTITY();

##</code><code>##

SELECT CAST(scope_identity() AS int)