Examples
The following example declares a variable as nchar, assigns the current value of SESSION_USER to that variable, and then prints the variable with a text description.
DECLARE @session_usr nchar(30);
SET @session_usr = SESSION_USER;
SELECT 'This session''s current user is: '+ @session_usr;
GO