System function

• USER_ID to get the database user ID associated with a database user name.
• USER_ID() to get the database user ID associated with the current connection.
• USER_NAME to get the database user name associated with a database user ID.
• Either the SQL-92 CURRENT_USER or SESSION_USER functions to get the database user name associated with the current connection. In Transact-SQL these functions are implemented as synonyms for the USER_NAME() (USER_NAME specified without a database_user_ID parameter). The Transact-SQL function USER is also implemented as a synonym for USER_NAME().

Syntax

USER_ID ( [ 'user' ] )

Arguments

'user'

Is the username to be used. user is nchar. If a char value is specified, it is implicitly converted to nchar.

Return Types

smallint

Remarks

When user is omitted, the current user is assumed. Parentheses are required.

USER_ID can be used in the select list, in the WHERE clause, and anywhere an expression is allowed.

Examples

This example returns the identification number for user "Chintan".

SELECT USER_ID('Chintan') 

USER_ID().  other system functions like USER_NAME(), 
SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(), 
HOST_NAME().



Thanks