System function

Question

Hi In genral database what is the system function to get the current user's user id? Thanks

Arjun Panwar · Answer

Thanks to all

Chintan Rathod · Answer

Getting Database User Names or User IDs When connected to SQL Server 2000 use: 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')

Satyapriya Nayak · Answer

Hi Arjun USER_ID(). other system functions like USER_NAME() SYSTEM_USER SESSION_USER CURRENT_USER USER SUSER_SID() HOST_NAME(). Thanks