Get the last inserted row ID

Method 1 

INSERT INTO dbo.YourTableName (Columns.......) VALUES (...........)

SELECT SCOPE_IDENTITY() 

Method 2 

DECLARE @id int 

INSERT INTO dbo.YourTableName (Columns.......) VALUES (...........)

SET @id=@@identity

SELECT @id