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

Answer Posted / swapna

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

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter date and time literals in ms sql server?

681


What is change data capture (cdc) in sql server 2008?

755


What happens if the update subquery returns no rows in ms sql server?

791


What is an inner join?

708


How to optimize stored procedures in sql server?

833






Why would you use sql agent?

883


Why transaction is important?

721


What is the sql profiler?

689


What is @@rowcount in sql?

731


What is user-defined function?

726


How can you append an identity column to a temporary table?

624


What happens on checkpoint?

780


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

840


How to check if stored procedure is running in sql server?

647


What programming language would you use to create embedded functions in ssrs?

156