Ten evolution into binary (such as 8) to 1000)

xiaoxiao2021-03-06  116

Alter Proc Prc_num @num bigint

AS

Declare @numstr varchar (50)

Set @ numstr = ''

While (@num <> 0)

Begin

Set @ numstr = @ Numstr Convert (char (1), @num% 2)

Set @ Num = @ Num / 2

end

SELECT Reverse (@numstr)

EXEC PRC_NUM 8

转载请注明原文地址:https://www.9cbs.com/read-100067.html

New Post(0)