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

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

Question Posted / swapna

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / tejas

USER_ID no USER_NAME user name gives us the user name not the USER_ID

Is This Answer Correct ?

0 Yes

0 No

More SQL Server Interview Questions

What is the sql server agent?

Do you know what is difference between index seek vs. Index scan?

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

Does full backup break log chain?

How to read data in a table with "select" statements?

What is history table in sql server?

Can a table have 2 foreign keys?

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

What are statistics, under what circumstances they go out of date, how do you update them?

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

What is it unwise to create wide clustered index keys?

For more SQL Server Interview Questions Click Here