I always return the new ID as an output parameter:

CREATE PROCEEDURE sp_Insert_Student

(

@ID int = 0 OUTPUT, ---always give a default value

@StudentName varchar(30)...