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.