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

How to Check if table exists in sql server?

1183

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2544

What is the difference between varchar and varchar(max) datatypes?

1133

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

Where are stored procedures in sql server?

1122

What is bcp? When does it use?

986

What is subreport?

144

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What is transaction server auto commit?

1114

Benefits of Stored Procedures?

1037

What is temporal table?

934

What is a not null constraint?

1085

Can primary key be a foreign key?

1108

How to how to convert numeric expression data types using the convert() function??

1091

Do you know hot add cpu in sql server 2008?

1002