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 use transact-sql statements to access the database engine?

534


What are different types of statement?

520


What are parameterized reports?

160


What is the downside of using udf?

556


Mention the command used to rename the database.

532






How can we delete Duplicate row in table?

626


What is meant by dirty read?

550


Differentiate between a primary key and a unique key.

586


What do you mean by cardinality?

483


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1427


Give me any three differences between Truncate and Delete.

561


What is the cartesian product of table?

537


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

87


What is auditing in sql server?

499


How is sql used in sql server?

495