求将一个中一列数据导入到另外一个表中Sql语句

Question

原始表:
create table dbo.YW_WORKRECORDTYPE (
ITEMCODE    varchar(12) not null,
ITEMNAME    varchar(50) null,
PARENTCODE  varchar(12) null,
ISDEL   char(2) DEFAULT   '0'       null
)目的表:
create TABLE tmp_callin          
(          
        TOperaName      VARCHAR(15) NULL, /*业务*/        
        TOperaNum       INT NULL,               /*数量*/        
        TRate           VARCHAR(13) NULL /*占总业务的百分比*/      
)现在我想要将YW_WORKRECORDTYPE 中ITEMNAME这一列数据复制到
tmp_callin的TOperaName中 
求SQL语句,谢谢!

Answer 1

insert into tmp_call(TOperaName) select ITEMNAME from YW_WORKRECORDTYPE 

Answer 2

insert tmp_callin(TOperaName)
select itemname from YW_WORKRECORDTYPE 

Answer 3

insert into tmp_callin
select ITEMNAME    ,null,null
from YW_WORKRECORDTYPE 

Answer 4

insert into tmp_callin(TOperaName) select ITEMNAME from YW_WORKRECORDTYPE 

Answer 5

insert tmp_callin(TOperaName) select itemname from YW_WORKRECORDTYPE