To get the proc name dynamically

In order to get the proc name dynamically in SQL we can use

Select @procName = object_name(@@procid)