SQL Server Database Administrator Question:
Download Questions PDF

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

Answer:

USER_ID().

Also check out other system functions like
USER_NAME(),
SYSTEM_USER,
SESSION_USER,
CURRENT_USER,
USER, SUSER_SID(),
HOST_NAME().

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What are cursors?
Explain different types of cursors?
What are the disadvantages of cursors?
How to avoid cursors?
What is a join and explain different types of joins?