获取当前登录用户ID

@userid为获取当前登录用户ID @username 为获取当前登录用户名

• 查询案例：获取当前登陆用户名
• 用途：将用户名与销售员设置相同，则可引用到报表内，例如按照登陆用户查看单据

DECLARE @userid varchar(20);
DECLARE @username varchar(20);
SELECT @userid = c.[userid], @username = c.[U_NAME]
FROM [master].[dbo].[sysprocesses] a
	INNER JOIN [dbo].[USR5] b
	ON a.[spid] = b.[SessionID]
		AND a.[hostprocess] = b.[ProcessID]
	INNER JOIN [dbo].[OUSR] c ON b.[UserCode] = c.[USER_CODE]
WHERE a.[spid] = @@spid
	AND b.[Action] = 'I'
ORDER BY b.[Date] DESC;

SELECT @userid , @username