说明
@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 声明：欢迎来到五六零学院。
