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;