fnFlag
Return
| Return Type |
|---|
| nvarchar(50) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @A | varbinary | IN | |
| @B | int | IN |
Definition
Copy
CREATE function [dbo].[fnFlag](@A varbinary(max),@B int) returns nvarchar(
50) as begin
declare @C nvarchar(50);declare @D nvarchar(10);set @C = CONVERT(
NVARCHAR(MAX), DECRYPTBYPASSPHRASE('sym_BBInfinity',@A));set @D = SUBSTRING(@C, 37, LEN(
CONVERT(NVARCHAR,@B)));If @D = convert(nvarchar,@B) set @C = left(
@C, 36); else set @C=convert(nvarchar,@D) Return @C; end