摘要:
declare@tabletable(tvarchar(500))declare@svarchar(500)set@s='你好啊hello123';declare@lenintset@len=len(@s)declare@iint,@jintset@i=1set@j=0while@i<=@lenbeginwhile@j<@lenand@j<(@len-@i+1)beginset@j=@j+1declare@tvarchar(500)set@t=SubString(@s,@i,@j)ifnotexists(selecttop11from@tablewheret= 阅读全文