insert into Expro_lists([GTitle],[GStartTime],[GEndTime],[GProvince],[GCity],[GExproAddress],[GSort],[GDesctription],[GHostCompany],[GPublicanCompany],[GLinkMan],[GPhone],[GFax],[GAddress],[GEmail],[GUserName])
select 展会名称,starttime,endtime,province,city,会展场馆,Sort,cast(展会说明 as varchar(7889)),主办单位,承办单位,[联 系 人],联系电话,[传  真],[地  址],[邮  件],'manage' from Expros
posted on 2009-03-21 12:16  bestsaler  阅读(101)  评论(0编辑  收藏  举报