create or alter function dbo.sdec ( @i varchar(255) )
returns bigint
as
begin
declare @c tinyint = 1;
declare @l tinyint = len(@i);
declare @o bigint = cast(substring(@i, @l, 1) as bigint);
while(@c < @l)
begin
set @o = @o + power(cast(substring(@i, @l-@c, 1) * 2 as bigint), @c);
set @c = @c + 1;
end
return @o;
end
go
create or alter function dbo.sbin ( @i bigint )
returns varchar(255)
as
begin
declare @o varchar(255) = “;
while @i > 0
begin
set @o = @o + cast((@i%2) as varchar);
set @i = @i/2;
end
return reverse(@o);
end
go
SELECT dbo.sbin(2)
SELECT dbo.sdec(‚100110111‘)
SELECT dbo.sbin(dbo.sdec(256))
select row_number() over(order by name asc) r,
dbo.sbin(row_number() over(order by name asc))
from sys.all_objects
order by 1 desc;