USP_GETAUTOLOGENCRYPTEDTOKEN

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(100)	IN
@TOKEN	nvarchar(1000)	INOUT

Definition

Copy



        create procedure dbo.USP_GETAUTOLOGENCRYPTEDTOKEN
        (
                @ID nvarchar(100),
                @TOKEN nvarchar(1000) = null output
        )
        as
                DECLARE @RESULTS xml
                EXEC dbo.USP_GET_KEY_ACCESS 
                SET @TOKEN  = EncryptByKey(Key_GUID('sym_BBInfinity'), @ID)
                CLOSE symmetric key sym_BBInfinity;
                set @RESULTS = (SELECT CONVERT(varbinary(max), CONVERT(nvarchar(max),@TOKEN))
                FOR XML PATH (''))

                select @TOKEN = @RESULTS.value('.', 'nvarchar(max)')
            return 0