T-SQL 解决"易语言难题"

2014/10/23 47327

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
declare @i int
declare @j int
declare @str varchar(20)
set @i = 123
while @i < 999/3
begin
    select @str = convert(varchar,@i)  +' '+
              convert(varchar,@i*2)+' '+
              convert(varchar,@i*3),
              @j = 1, @i = @i + 1
    while @j <= 9   
    begin
        if charindex(convert(varchar,@j),@str) <= 0 break
        set @j = @j + 1
    end
    if @j >= 10 print @str
end