SqlServer两个字段字符中字符是否包含比对。

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[bijiao]

AS
BEGIN
 
SET NOCOUNT ON;
declare @id nvarchar(255)
declare @name nvarchar(255)
declare @des nvarchar(255)

declare my_cursor cursor for
select id,name,des from A

open my_cursor

fetch next from my_cursor
into @id,@name,@des

while @@fetch_status= 0
begin

if ( (not  @name is null) and  ( not @des is null) )
 begin

   declare @length int

   declare @i int
   set @i =1
   set @length = len( @name)

   while ( @i< @length + 1 )
   begin
      declare @chr nvarchar(10)
      set @chr= substring(@name,@i,1)
      if charindex(@chr,@des) >0
      begin
         update A set  Code = 'YES' where id = @id
      end    
      set @i = @i + 1
   end

end

fetch next from my_cursor
into @id,@name,@des

end
close my_cursor
deallocate my_cursor

END