| description | APP_NAME (Transact-SQL) | |||||
|---|---|---|---|---|---|---|
| title | APP_NAME (Transact-SQL) | Microsoft Docs | |||||
| ms.custom | ||||||
| ms.date | 07/24/2017 | |||||
| ms.prod | sql | |||||
| ms.prod_service | database-engine, sql-database | |||||
| ms.reviewer | ||||||
| ms.technology | t-sql | |||||
| ms.topic | reference | |||||
| f1_keywords |
|
|||||
| dev_langs |
|
|||||
| helpviewer_keywords |
|
|||||
| ms.assetid | e491e192-9b30-4243-bc19-33c133fe08a8 | |||||
| author | cawrites | |||||
| ms.author | chadam |
[!INCLUDE SQL Server SQL Database]
This function returns the application name for the current session, if the application sets that name value.
Important
The client provides the application name, and APP_NAME does not verify the application name value in any way. Do not use APP_NAME as part of a security check.
Transact-SQL Syntax Conventions
APP_NAME ( )
[!INCLUDEsql-server-tsql-previous-offline-documentation]
nvarchar(128)
Use APP_NAME to distinguish between different applications, as a way to perform different actions for those applications. For example, APP_NAME can distinguish between different applications, which allows for a different date format for each application. It can also allow for the return of an informational message to certain applications.
To set an application name in [!INCLUDEssManStudio], click Options in the Connect to Database Engine dialog box. On the Additional Connection Parameters tab, provide an app attribute in the format ;app='application_name'
This example checks whether the client application that initiated this process is a SQL Server Management Studio session. It then provides a date value in either US or ANSI format.
USE AdventureWorks2012;
GO
IF APP_NAME() = 'Microsoft SQL Server Management Studio - Query'
PRINT 'This process was started by ' + APP_NAME() + '. The date is ' + CONVERT ( VARCHAR(100) , GETDATE(), 101) + '.';
ELSE
PRINT 'This process was started by ' + APP_NAME() + '. The date is ' + CONVERT ( VARCHAR(100) , GETDATE(), 102) + '.';
GO