SQL Tutorial

SQL Advanced

SQL Database

SQL References

SQL Tutorial

SQL Advanced

SQL Database

SQL References

SQL Server SESSION_USER Function

The SQL Server (Transact-SQL) SESSION_USER function returns the user name of the current session in the SQL Server database.

Syntax

SESSION_USER

Parameters

No parameter is required.

Return Value

Returns the user name of the current session in the SQL Server database.

Example:

The example below shows the usage of SESSION_USER function.

SELECT SESSION_USER;

The above query will return the user name of current session in the SQL Server database. Therefore if the SQL Server account that was used was 'za108909', it will return the following:

SELECT SESSION_USER;
Result: 'za108909'

❮ SQL Server Functions

AlphaCodingSkills

AlphaCodingSkills Android App

AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.