USER_NAME() Function in SQL Server

USER_NAME() :

This function in SQL Server is used to return the username of the database that is based on the id stated.

Features :

This function is used to find the username of the database used.
This function comes under Advanced Functions.
This function accepts only one parameter i.e, id number.
This function returns the current user’s name in case the id number is not specified.

Syntax :

USER_NAME(id_number)

Parameter :

This method accepts only one parameter.

id_number – Specified id number in the database of the user. It is optional.

Returns :

It returns the username of the specified id number. Moreover, if the id number is not specified then it returns the current username.

Example-1 :

Using the USER_NAME() function and getting the username with no id number.

SELECT USER_NAME();

Output :

nidhi

Here, the id number is not provided so, the current user’s name is returned.

Example-2 :

Using the USER_NAME() function and getting the username of the specified id number.

SELECT USER_NAME(2);

Output :

Geek

Example-3 :

Using the USER_NAME() function and getting the username of the specified id number using a variable.

DECLARE @id INT;
SET @id = 3;
SELECT USER_NAME(@id);

Output :

INFORMATION_SCHEMA

Example-4 :

Using the USER_NAME() function and getting the username of the specified id number using the CAST() function.

SELECT USER_NAME(CAST(2.2 as int));

Output :

Geek

Application :

This function is used to find the username of the database used.

Article Tags :

SQL