@@PROCID (T-SQL)

Returns the stored procedure ID of the current procedure.

Syntax

@@PROCID

Return Types

integer

Examples

This example creates a procedure that uses SELECT to display the @@PROCID setting from inside the procedure.

CREATE PROCEDURE testprocedure AS

SELECT @@PROCID AS 'ProcID'

GO

EXEC testprocedure

GO

  

See Also
CREATE PROCEDURE Metadata Functions

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.