将1和0的32位二进制字符串转换为SQL Server中的带符号十进制数

您可以尝试如下-

DECLARE @Binary VARCHAR(100) = '01010010000100010111001101110011';
DECLARE @characters CHAR(36),  
        @result BIGINT,  
        @index SMALLINT,  
        @base BIGINT;
SELECT @characters = '0123456789abcdefghijklmnopqrstuvwxyz',  
       @result = 0,  
       @index = 0,
       @base = 2;    
WHILE @index < LEN(@Binary)
BEGIN 
     SELECT @result = @result + POWER(@base, @index) * (CHARINDEX(SUBSTRING(@Binary, LEN(@Binary) - @index, 1), @characters) - 1);
     SET @index = @index + 1;  
END
SELECT @result;

这将帮助您从任何基数（我用于@base as 2二进制）转换为基数10。从最右边开始，一直向左移动，直到数字用完。转换是（基础^索引）*数字。