T-SQL-按字符比较字符串char

对于您不想使用逐行方法的表中的列，请尝试以下一种方法：

with cte(n) as (    select 1    union all    select n + 1 from cte where n < 9)select    t.s1, t.s2,    sum(      case      when substring(t.s1, c.n, 1) <> substring(t.s2, c.n, 1) then 1      else 0      end    ) as difffrom test as t    cross join cte as cgroup by t.s1, t.s2

= > SQL小提琴演示