why we use SELECT @@IDENTITY at last in Stored procedure sql

Hi Mani,

 Your question is right. Most of stored procedures have @@IDENTITY. We use this to fetch that last identity column value. (Identity column is a column which we set to auto increament. Mostly we make it primary, sometimes not. But without declaration it can we used as Primary Key. Duplicate record never inserted there  )

When we insert a record in table, then we don't know that which record inserted there. After the record insertion @@IDENTITY provide us that record key, which stored in identity column. 

You can refer http://csharp-video-tutorials.blogspot.com/2012/08/identity-column-in-sql-server-part-7.html

or for video tutorial https://www.youtube.com/watch?v=aOkFE6NLGCQ