SQL我在临时表中插入一个新列后,执行怎么就不显示表结果了,代码和图如下

select * into #productsku1 from TProductSku where ProductSkuId in (select productskuid from #productskuqty)select b.ProductType as silo,a.ClassId1,a.ClassId2,b.ClassName as classid3,a.ProductSkuId,ProductSkuName,c.qty into #productsku2 from #productsku1 a left join TProductClass3 b on a.ClassId3=b.ClassIdleft join #productskuqty c on a.ProductSkuId=c.ProductSkuIdselect silo,ClassId1,ClassId2 ,sum(qty) as qty from #productsku2group by silo,ClassId1,ClassId2order by silo,ClassId1,ClassId2
select silo,ClassId1,ClassId2,sum(qty) as qty,convert(varchar ,(sum(qty)/sum(qty))*100) +'%' as percen
into #productsku9
from #productsku2
group by silo,ClassId1,ClassId2
order by silo,ClassId1,ClassId2

select * into 并不是查询语句
而是将数据和结构复制到新的表里去
你要查的话重新到最后写一条
select * from 表名追问

不是查询,是将结果集显示出来,就像这样

温馨提示:内容为网友见解,仅供参考
无其他回答
相似回答