SQL Server - System Functions

This article describes the Transact-SQL system functions supported by Microsoft SQL Server.

Overview

Function	Description

APP_NAME()	Returns the application name for the current session
OBJECT_NAME()	Returns the database object name
@@PROCID	Returns the object identifier (ID) of the current Transact-SQL module

SQL Server - APP_NAME
Syntax	APP_NAME()
Description	Returns the application name for the current session if set by the application
Return Type	NVARCHAR(128)

Equivalents in Other Databases

Database	Equivalent
Oracle	The PROGRAM column in the V$SESSION system view, see Return Application Name in Oracle

SQL Server - OBJECT_NAME
Syntax	OBJECT_NAME(object_id)
Parameter	ID of the object. object_id is INT
Description	Returns the database object name for the specified object ID
Return Type	sysname

SQL Server - @@PROCID
Syntax	@@PROCID
Description	Returns the object identifier (ID) of the current Transact-SQL module. A Transact-SQL module can be a stored procedure, user-defined function, or trigger.
Remarks	@@PROCID cannot be specified in CLR modules or the in-process data access provider.
Return Type	int