比较每个对应位置上字符相等的个数

--
--@char @char1 长度一样 算法的意义是 比较每个对应位置上字符相等的个数
--
declare @char nvarchar(max) = 'abshijz'
declare @char1 nvarchar(max) = 'abphijk'
declare @n int
declare @result int
set @result =0
set @n = 1
while @n <= LEN(@char)
begin
if
(select substring(@char,@n,1)) = (select substring(@char1,@n,1))
begin
set @result =@result+1
end
set @n=@n+1
end
print @result