|
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,@des
end
close my_cursor
deallocate my_cursor
END
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
