How to get inserted ID after we fire INSERT Query.

Here is the solution which will give you ID of record which is recently inserted in SQL.

select @@identity as id

You can check this Query after INSERT statement. So you will get the ID of new row inserted.