DotNetShoutout - Findout Calling procedure name using @@PROCID

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

7
Shouts

Shout it

Findout Calling procedure name using @@PROCID

published 620 days, 16 hours, 2 minutes ago posted by

dhara 620 days, 22 hours, 12 minutes ago

Suppose you want to find out the name of the procedure that calls the procedure being executed,you can use system function @@PROCID which returns the object id of the current procedure.

category: SQL | clicked: 0 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout