Function: [AdventureWorks2016CTP3].[dbo].[AUDIT_fn_HexToStr]

CollapseAll image

Collapse image Function properties


 Name   Value 
 Schema   [dbo] 
 Owner   [dbo] 
 Creation date   21.09.2016 
 Type   Scalar 
 Is schema bound   
 Is deterministic   
 Encrypted   
 Implementation type   Transact SQL 
 ID   120387498 

Collapse image Creation options


Name Value
QUOTED_IDENTIFIER ON
ANSI_NULLS ON

Collapse image Parameters


Name  Description DataType  Max length  ReadOnly
@hex   varbinary 8000  

Collapse image Recordset returned


Name  Datatype  Max length 
@Return varchar 8000

Collapse image Objects that depend on [dbo].[AUDIT_fn_HexToStr]


Object name Object type Dep level
[dbo].[AUDIT_fn_SqlVariantToString] Function 1
Total 1 object(s)

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

create function [dbo].[AUDIT_fn_HexToStr](@hex varbinary(8000))
returns varchar(8000)
as
begin
declare 
    @len int,
    @counter int,
    @res varchar(8000),
    @string char(16),
    @byte binary(1)
    set @string = '0123456789ABCDEF'
    set @res = '0x'
    set @len = datalength(@hex)
    set @counter = 1
    while(@counter <= @len)
    begin
        set @byte = substring(@hex, @counter, 1)
        set @res = @res + substring(@string, 1 + @byte/16, 1) + substring(@string, 1 + @byte - (@byte/16)*16, 1)
        set @counter = @counter + 1
    end
    return @res
end
GO

Collapse image See also


List of functions