How to convert from decimal to binary in SQL Server? Write the Script/Query, Interview Question 2016
Write a function to convert decimal number to binary number in SQL Server? (asked during Genpact interview Jun 2016)
Ans:
Ans:
CREATE FUNCTION
fn_ConvertFromDecimal2Binary
( @Num int )
RETURNS VARCHAR(30)
AS
BEGIN
DECLARE @quot int
DECLARE @Rem int
DECLARE @Res varchar(30) = ''
Set @quot= @Num
While(@quot>1)
BEGIN
SET @Rem = @quot%2
SET @quot = @quot/2
SET @Res= CONVERT(varchar(30),@Rem)+ @Res
END
SET @Res = (CONVERT(varchar(30),@quot) + @Res)
RETURN @Res
END
GO
CREATE FUNCTION fn_ConvertFromDecimal2Binary
ReplyDelete( @Num int )
RETURNS VARCHAR(30)
AS
BEGIN
DECLARE @quot int
DECLARE @Rem int
DECLARE @Res varchar(30) = ''
Set @quot= @Num
While(@quot>1)
BEGIN
SET @Rem = @quot%2
SET @quot = @quot/2
SET @Res= CONVERT(varchar(30),@Rem)+ @Res
END
SET @Res = (CONVERT(varchar(30),@quot) + @Res)
RETURN @Res
END
GO