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