use ScoreCard insert into SCORE_CARD_REALTIME(FactoryID,Category1,Category2,YesterdayTarget,YesterdayActual,TodayTarget,TodayActual,UpdateUser,DataTimestamp)
select FactoryID,Category1,Category2,YesterdayTarget,YesterdayActual,TodayTarget,TodayActual,UpdateUser,DataTimestamp from MfgOrders.dbo.SCORE_CARD_REALTIME
原表存在的话这样用:
insert into a select * from b
原表不存在的话这样用:
select * into a from b