提问题：数据复制的问题

Question

insert into Jason.pricecenter.dbo.product_temp(code,[name],kind,source,unit,price,product_intro,factory,stock_price,other) select code,[name],kind,source,unit,price,product_intro,factory,stock_price,other from Jason.pricecenter.dbo.product where product_temp.number=product.number

Answer 1

insert into Jason.pricecenter.dbo.product_temp(code,[name],kind,source,unit,price,product_intro,factory,stock_price,other) select code,[name],kind,source,unit,price,product_intro,factory,stock_price,other from Jason.pricecenter.dbo.product

Answer 2

insert into Jason.pricecenter.dbo.product_temp(
       code,[name],kind,source,unit,price,product_intro,factory,stock_price,other) 
select code,[name],kind,source,unit,price,product_intro,factory,stock_price,other from Jason.pricecenter.dbo.product

Answer 3

insert into Jason.pricecenter.dbo.product_temp(code,[name],kind,source,unit,price,product_intro,factory,stock_price,other) 
select code,[name],kind,source,unit,price,product_intro,factory,stock_price,other from Jason.pricecenter.dbo.product,Jason.pricecenter.dbo.product_temp where product_temp.number=product.number

Answer 4

from Jason.pricecenter.dbo.product,Jason.pricecenter.dbo.product_temp where product_temp.number=product.number
--------------------------------------------------------------
Jason.pricecenter.dbo.product_temp你少写了这个表