[SQL]十進制轉二進制 用Function實現

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[FN_Convert10To2Bin](@i INT)

RETURNS VARCHAR(31)

AS

BEGIN

    DECLARE @str VARCHAR(31);

    SET @str=''

    WHILE (@i>0)

        SELECT @str=CAST(@i%2 AS VARCHAR(10))+@str, @i=@i/2

    RETURN(@str)

END

GO

呼叫方式

select dbo.[FN_Convert10To2Bin](10)

結果 1010