Search This Blog

Friday, February 10, 2017

Convert integer to hex

CREATE FUNCTION ToHex(@value int)
RETURNS varchar(50)
AS
BEGIN
    DECLARE @seq char(16)
    DECLARE @result varchar(50)
    DECLARE @digit char(1)
    SET @seq = '0123456789ABCDEF'

    SET @result = SUBSTRING(@seq, (@value%16)+1, 1)

    WHILE @value > 0
    BEGIN
        SET @digit = SUBSTRING(@seq, ((@value/16)%16)+1, 1)

        SET @value = @value/16
        IF @value <> 0 SET @result = @digit + @result
    END

    RETURN @result
END
GO
--------------------------------------------------------
select dbo.ToHex(091)
select dbo.ToHex(12408441)


Thursday, February 2, 2017

exec SP Data to store a variable in SQL Server

DECLARE @Output1 VARCHAR(100), Output2 VARCHAR(100)

CREATE TABLE #tmpTable
(
    OutputValue1 VARCHAR(100), OutputValue2 VARCHAR(100),
)
INSERT INTO #tmpTable (OutputValue1,OutputValue2)
EXEC dbo.sp_name

SELECT
    @Output = OutputValue1, Output2= OutputValue2
FROM 
    #tmpTable

DROP TABLE #tmpTable
print @Output1