Getting Last inserted Identity value in SQL server

Dear Friends


 Here i'm writing sql query by which you can get currently inserted rows identity column value


declare @id as int
set @id=SELECT IDENT_CURRENT(‘TableName’)




to use this your table must have an identity column