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

2 Answers
13359 Views
HCL, I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

What is ems sql management studio? : sql server management studio

0 Answers

What are the advantages to use stored procedures?

0 Answers Ernst Young,

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers

Mention the different authentication modes in sql server.

0 Answers

What is ddl and dml commands?

0 Answers

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers

Do you know what is blocking?

0 Answers

Explain the concepts and capabilities of sql server?

0 Answers

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers

For more SQL Server Interview Questions Click Here