SYSTEM_USER

Allows a system-supplied value for the current login to be inserted into a table when no default value is specified.

Syntax

SYSTEM_USER

Return types

sysname

Example

DECLARE @sys_usr char(30);  
SET @sys_usr = SYSTEM_USER;  
SELECT 'The current system user is: '+ @sys_usr;

See Also