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

Differentiate between mongodb vs. Sql server?

587

Tell me what do you understand by a view? What does the with check option clause for a view do?

647

What is xml datatype?

663

What is subquery explain with example?

617

Explain how would you store your query in an SSRS report or a Database server?

What are Row versions of DataRow?

612

what is memory-optimized nonclustered indexes

564

How to modify an existing user defined function?

604

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

116

What are system databases into sql server (2005/2008)?

592

Tell about MOM Tool(Microsoft Operator Manager)?

1414

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

599

How to Sync Two SQL Azure Databases?

101

Mention the differences between having and where clause.

560

Explain error and transaction handling in sql server?

508