SQL Server Video to return the procedure name using @@PROCID


By:   |   Updated: 2014-07-14   |   Comments   |   Related: More > Stored Procedures




 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

The input parameter @@PROCID returns the object_id of the current stored procedure, function or trigger. This video shows how to use @@PROCID in a stored procedure to get the schema and procedure name. It also corrects a misperception that appears in some places on the internet that @@PROCID would let you know which procedure initiated a trigger. It doesn't do that and that problem is demonstrated.

Key Learning Items
  • Using @@PROCID with OBJECT_NAME
  • Using @@PROCID with OBJECT_SCHEMA_NAME
  • How to use @@PROCID to always return the correct name of the procedure
  • What happens when you use @@PROCID inside of a trigger
Read Companion Tip
Click Here




get scripts

next tip button



About the author
MSSQLTips author Andy Novick Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience.

View all my tips


Article Last Updated: 2014-07-14

Comments For This Article





download














get free sql tips
agree to terms