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.