删除包含汉字的记录

Declare @temp int
Declare @memberName varchar(255)
Declare @MemberID int
declare @tempstr varchar(5000)
DECLARE authors_cursor CURSOR FOR
SELECT MemberID,MemberName
FROM Member  where MemberID>=100000

open authors_cursor

fetch next from authors_cursor  into @MemberID, @memberName
while @@fetch_status=0
begin
--print @memberName

--set @tempstr=
--瓒呯骇濂崇敓 鎯婅壋濠€濞滄按妗惰叞
set @temp=dbo.find_regular_expression(@memberName,'([/u4e00-/u9fa5]|[/uFE30-/uFFA0]|[/u0800-/u4e00]|[-]){1,50}',0)

/*if @temp=1  --合法
 begin
 update Member set Valid=0 where MemberID=@MemberID
 end
else */
if @temp=1
 begin
 --delete Member  where MemberID=@MemberID
 delete Member where Current of authors_cursor
 end
fetch next from authors_cursor into @MemberID, @memberName
end
--print @temp

CLOSE authors_cursor
DEALLOCATE authors_cursor