USP_REGISTER_CMS_AUTOLOG_TOKEN

Register CMS token for login validation

Parameters

Parameter Parameter Type Mode Description
@TOKEN uniqueidentifier IN
@USERID int IN
@CACHELENGTH int IN

Definition

Copy


create procedure dbo.USP_REGISTER_CMS_AUTOLOG_TOKEN
(
  @TOKEN uniqueidentifier,
  @USERID int,
  @CACHELENGTH int = 45
)
as
begin
  declare @EXPIRATION datetime,
          @uid nvarchar(8)
  set @uid=cast(@USERID as nvarchar(8))
    set @EXPIRATION = DATEADD(s, @CACHELENGTH, GetUTCDate());
    exec [dbo].[spTempDataAdd] @TOKEN, null, @uid, @EXPIRATION;
end