sql server advanced command
-
COALESCE statement in SQL Server
the coalesce statement returns the expression with the first non-null value among the passed expressions. -
Function SESSION_USER in SQL Server
the session_user statement returns the username of the current session in the sql server database. -
SYSTEM_USER function in SQL Server
the system_user statement returns the username of the current user in the sql server database.