sql函数的十进制转二进制函数

create function dectobin(@num bigint)
returns varchar(50)
as
begin
declare @numstr varchar(50)
while (@num<>0)
begin
set @numstr=@numstr+convert(char(1),@num%2)
set @num=@num/2
end
return reverse(@numstr)
end