导数据sql语句

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

转载于:https://www.cnblogs.com/bestsaler/archive/2009/03/21/1835732.html