一个sql编译不过去

[sunke5843323]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234,BoardID,0 from Temp_Assign where CommType='04' order by EleUsedCount
union
select top 2 234,BoardID,0 from Temp_Assign where CommType='05' order by EleUsedCount

[叶子]

234,BoardID,0这是字段名吗？

[zccmy22]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 [234],BoardID,[0] from Temp_Assign where CommType='04' order by EleUsedCount
union
select top 2 [234],BoardID,[0] from Temp_Assign where CommType='05' order by EleUsedCount

数字字段要加[]

如果不是字段。

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234 as a,BoardID,0 as b from Temp_Assign where CommType='04' order by EleUsedCount
union
select top 2 234 as a,BoardID,0 as b from Temp_Assign where CommType='05' order by EleUsedCount

[贫僧又回来了]

什么错误啊?

[zccmy22]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234 as MainID,BoardID,0 as Besure from Temp_Assign where CommType='04' order by EleUsedCount
union
select top 2 234 as MainID,BoardID,0 as Besure from Temp_Assign where CommType='05' order by EleUsedCount

[hackztx]

[code=SQL]
insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234,BoardID,0 from Temp_Assign where CommType='04'
union
select top 2 234,BoardID,0 from Temp_Assign where CommType='05' order by EleUsedCount
[\code]

[叶子]

分开插入就行了

insert into ProjectDetail(MainID,BoardID,Besure) 
select top 1 字段1,字段2,字段3 from Temp_Assign where CommType='04' order by EleUsedCount ;
insert into ProjectDetail(MainID,BoardID,Besure) 
select top 2 字段1,字段2,字段3 from Temp_Assign where CommType='05' order by EleUsedCount ;

[叶子]

要注意对应类型的匹配

[hackztx]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234,BoardID,0 from Temp_Assign where CommType='04' 
 union 
select top 2 234,BoardID,0 from Temp_Assign where CommType='05' order by EleUsedCount 

[boblaw]

修改如下：

insert into ProjectDetail(MainID,BoardID,Besure) 
select 234,BoardID,0 from 
(
select top 1 BoardID,EleUsedCount from Temp_Assign where CommType='04'
 union  
select top 2 BoardID,EleUsedCount from Temp_Assign where CommType='05'
)
a
order by CommType,EleUsedCount

[Tord_zhang]

values

[sunke5843323]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 234,BoardID,0 from Temp_Assign where CommType='04'
union select top 2 234,BoardID,0 from Temp_Assign where CommType='05' order by EleUsedCount
这样写的话第一个select会不会排序呢

[boblaw]

上面寫錯了，改為如下：

insert into ProjectDetail(MainID,BoardID,Besure) 
select 234,BoardID,0 from (select top 1 BoardID from Temp_Assign where CommType='04' order by EleUsedCount) a
 union  
select 234,BoardID,0 from (select top 2 BoardID from Temp_Assign where CommType='05' order by EleUsedCount)b

[virusswb]

insert into ProjectDetail(MainID,BoardID,Besure)
select top 1 [234],[BoardID],[0] from Temp_Assign where CommType='04' order by EleUsedCount
 union 
select top 2 [234],[BoardID],[0] from Temp_Assign where CommType='05' order by EleUsedCount

你的列名怎么可以使用数字呢，数字开头是不对的

[sunke5843323]

我想分别取 CommType='04' 的EleUsedCount 最小的一条记录
CommType='05' 的EleUsedCount 最小的两条记录



insert into ProjectDetail(MainID,BoardID,Besure)
select 234,BoardID,0 from
(
select top 1 BoardID,EleUsedCount from Temp_Assign where CommType='04'
union
select top 2 BoardID,EleUsedCount from Temp_Assign where CommType='05'
)
a
order by CommType,EleUsedCount
这样写先取后排，结果是不是不正确啊