| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
APP_NAME (Transact-SQL) | APP_NAME (Transact-SQL) | markingmyname | maghan | 07/24/2017 | sql | t-sql | reference |
|
|
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
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.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
APP_NAME ( ) 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 AdventureWorks2022; 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 