SQL2005问题

insert into assignhistroy(字段1,字段2...)select 字段1，字段2...from

解决方案 »

  1.   

    TDUMP表的数据如下：cur_staff ascount       handleby cur_rolegroup objectivetype_id custlists
    --------- ----------- -------- ------------- ---------------- ------------
    27B365    3           447A11   Farmer        559CAC           CustList_test0924
    2EB508    2           447A11   Farmer        559CAC           CustList_comebaby
    2EB508    1           447A11   Farmer        559CAC           CustList_test0924
    320DAA    2           447A11   Farmer        559CAC           CustList_comebaby
    8BBEFE    1           447A11   Farmer        559CAC           CustList_comebaby
    8BBEFE    1           447A11   Farmer        559CAC           CustList_test0924
      

  2.   


    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP
      

  3.   

    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP
      

  4.   

    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP
      

  5.   

    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP
      

  6.   

    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP
      

  7.   

    insert into assignhistroy(fname,assignnum,handleby,fcode,objectivetype_id,customertype)
    select cur_staff,ascount,handleby,cur_rolegroup,objectivetype_id,custlists  from TDUMP