Skip to content

app-name-transact-sql.md

Latest commit

 

History

History
75 lines (61 loc) · 2.9 KB

app-name-transact-sql.md

File metadata and controls

75 lines (61 loc) · 2.9 KB
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.service
ms.component t-sql|functions
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
APP_NAME_TSQL
APP_NAME
dev_langs
TSQL
helpviewer_keywords
name checking for current session [SQL Server]
sessions [SQL Server], application names
applications [SQL Server], names
current session application names
APP_NAME function
ms.assetid e491e192-9b30-4243-bc19-33c133fe08a8
caps.latest.revision 35
author edmacauley
ms.author edmaca
manager craigg
ms.workload On Demand

APP_NAME (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

A function that returns the application name for the current session, if the application sets that name value.

Important

The client provides the application name and the application name value is not verified in any way. Do not use APP_NAME as part of a security check.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
APP_NAME  ( )

Return Types

nvarchar(128)

Remarks

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 to allow 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'

Example

This example checks whether the client application that initiated this process is a SQL Server Management Studio session, and provides a date 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

See also

System Functions (Transact-SQL)
Functions