COALESCE statement in SQL Server
the coalesce statement returns the expression with the first non-null value among the passed expressions.
Tags : sql server advanced command
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.