Insert Update stored procedure with Scope_Identity() SQL

reference:-  https://www.aspsnippets.com/Articles/Return-Identity-value-from-Stored-Procedure-in-SQL-Server.aspx