摘要: 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= 阅读全文
posted @ 2011-08-30 11:32 青羽 阅读(354) 评论(0) 推荐(0) 编辑