根据0~20的与运算总结

 _{0~20与运算}

---

根据0~20的与运算总结以下几点规则:

---

经观察后面的规则难以总结,如有答案请留言给我.谢谢!

Create FUNCTION DecToBin(@Dec Int)
RETURNS VARCHAR(16)
AS
begin
 declare @BinStr as varchar(20)
 declare @Mod2 as int 
 declare @Div2   as int

 

 set @Div2 = @Dec / 2
 set @Mod2 = @Dec % 2
 set @BinStr=''

 

 while @Div2<>0
 begin
  if @Mod2=0 
   set @BinStr = @BinStr + '0'
  else 
   set @BinStr = @BinStr + '1'
 
  set @Dec = @Dec / 2
  set @Div2 = @Dec / 2
  set @Mod2 = @Dec % 2 
 end
 
 set @BinStr = @BinStr + '1'
 
 return REVERSE(@BinStr + right('0000000000000000',16-len(@BinStr)))
end