--> 测试数据[TB1]
if object_id('[TB1]') is not null drop table [TB1]
go
create table [TB1]([notext] nvarchar(20),[blu] nvarchar(5))
insert [TB1]
select '13 14 16 26 35',' ' union all
select '13 14 16 27 35',' ' union all
select '13 14 16 31 32',' ' union all
select '13 14 16 32 33',' ' union all
select '13 14 16 32 35',' ' union all
select '13 14 17 26 35',' ' union all
select '13 14 17 32 35',' ' union all
select '13 14 18 27 35',' ' union all
select '13 14 18 29 34',' ' union all
select '13 14 18 30 33',' ' union all
select '13 14 18 30 35',' ' union all
select '13 14 18 31 34',' ' union all
select '13 14 18 31 35',' ' union all
select '13 14 18 32 35',' ' union all
select '13 14 18 33 34',' ' union all
select '13 14 19 32 33',' ' union all
select '13 14 19 32 34',' ' union all
select '13 14 19 32 35',' ' union all
select '13 14 20 27 35',' ' union all
select '13 14 20 32 33',' ' union all
select '13 14 20 32 35',' ' union all
select '13 14 21 27 35',' ' union all
select '13 14 21 32 34',' ' union all
select '13 14 21 32 35',' ' union all
select '13 14 22 28 35',' ' union all
select '13 14 22 32 33',' ' union all
select '13 14 23 26 35',' ' union all
select '13 14 24 27 35',' ' union all
select '13 14 25 26 35',' ' union all
select '13 14 25 27 34',' ' union all
select '13 14 25 27 35',' ' union all
select '13 14 25 28 35',' ' union all
select '13 14 26 27 34',' ' union all
select '13 14 26 27 35',' ' union all
select '13 14 26 28 33',' ' union all
select '13 14 26 29 33',' ' union all
select '13 14 27 28 33',' ' union all
select '13 14 27 29 32',' ' union all
select '13 14 27 30 31',' ' union all
select '13 15 16 32 34',' ' union all
select '13 15 18 29 34',' ' union all
select '13 15 18 30 34',' ' union all
select '13 15 18 30 35',' ' union all
select '13 15 18 33 34',' ' union all
select '13 15 18 33 35',' ' union all
select '13 15 21 32 34',' ' union all
select '13 15 24 26 35',' ' union all
select '13 15 25 26 35',' ' union all
select '13 16 17 32 33',' ' union all
select '13 16 17 32 34',' ' union all
select '13 16 18 28 35',' ' union all
select '13 16 18 29 35',' ' union all
select '13 16 18 30 35',' ' union all
select '13 16 18 31 34',' ' union all
select '13 16 18 32 35',' ' union all
select '13 16 18 33 34',' ' union all
select '13 16 18 33 35',' ' union all
select '13 16 19 28 35',' ' union all
select '13 16 20 28 35',' ' union all
select '13 16 20 32 33',' ' union all
select '13 16 21 32 33',' ' union all
select '13 16 22 28 35',' ' union all
select '13 16 24 27 35',' ' union all
select '13 16 25 26 35',' ' union all
select '13 17 18 30 34',' ' union all
详细解决方案
怎么把蓝号组合到表[TB1]里的[blu]字段里
热度:56 发布时间:2016-04-24 10:32:22.0
相关解决方案