USP_GETCLIENTUSERSLOGINHISTORY
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @USERID | int | IN |
Definition
Copy
create procedure dbo.USP_GETCLIENTUSERSLOGINHISTORY
(
@USERID int
)
as
begin
select top 10 ID, [USERID], [USERAGENT], [DATELASTLOGIN]
from dbo.CLIENTUSERSLOGINHISTORY(nolock)
where USERID=@USERID
order by DATELASTLOGIN desc
end;