Question

SQL报错求助

Select * into TC from(
select t1.ItemCode as 物料单号,t1.dscription as 物料名称,t1.quantity as 数量,t0.TaxDate,T3.SalUnitMsr as 单位,
ISNULL((((t1.U_StdPrice)*(t1.quantity))/(t1.quantity )),0) as 单价
FROM OINV t0
left join inv1 t1 on t1.docentry=t0.docentry
left join OVTG t2 on t1.VatGroup=t2.code
left join OITM T3 on T3.Itemcode=t1.ItemCode
where T3.ItmsGrpCod ='119'
group by t1.ItemCode,t1.dscription,t1.quantity,t0.TaxDate,T3.SalUnitMsr,(((t1.U_StdPrice)*(t1.quantity))/(t1.quantity ))
)Ta
select * from TC

error information:
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'TC' in the database.

Answer 1

这是因为TC这张表已经在数据库里面有了，如果不想修改代码，可以先把数据库里面的这张表删掉，再执行就可以了。

如果看不到TC这张表，可以点击刷新按钮，如下图：

追问

既然已经存在TC表,那么执行select * from TC
为何没有数据显示

追答

单独执行了这个语句了吗？

Answer 2

TC是什么 表吗

insert into TC(values) select * from ...