USER_ID(). other system functions like USER_NAME(), SYSTEM

What is the system function to get the current user's user
id?

Question Posted / swapna

Answer Posted / swapna

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

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is molap and its advantage? : sql server analysis services, ssas

984

Can a database be shrunk with users active?

1122

Why do we use non clustered index?

1078

What is the new security features added in sql server 2016? : sql server security

1103

Explain what is the difference between a local and a global temporary table?

991

How many replicas are maintained for each SQL Azure database?

142

How to download and install sql server 2005 books online?

1178

What is 1nf 2nf?

1005

How would we use distinct statement? What is its use?

1069

What triggers long term care?

1027

What is the importance of three tier architecture?

1084

Why variables called the most powerful component of ssis?

1073

What is sub-query in sql server?

1199

What is a system database and what is a user database?

1080

What happens to a statement batch if there is a compilation error?

963