select top 500 IDENTITY(int,1,1) as id into # from syscolumns a,syscolumns b
declare @s1 varchar(500)
declare @s2 varchar(500)set @s1='10101010101100010101000011011011001'
set @s2='10100010110110010110011001100111110'select count(*)
from #
where substring(@s1,id,1)='1' and substring(@s2,id,1)='1'drop table #--结果
-----------
10(所影响的行数为 1 行)
declare @s1 varchar(500)
declare @s2 varchar(500)set @s1='10101010101100010101000011011011001'
set @s2='10100010110110010110011001100111110'select count(*)
from #
where substring(@s1,id,1)='1' and substring(@s2,id,1)='1'drop table #--结果
-----------
10(所影响的行数为 1 行)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货