update Expro_Lists set GDesctription=substring((select top 1 cast(展会说明 as varchar(7800)) from ExprosTemp where 展会名称=Expro_Lists.GTitle),1,6000)
update Expro_Lists set GDesctription=substring((select top 1 cast(展会说明 as varchar(7800)) from ExprosTemp where 展会名称=Expro_Lists.GTitle),1,6000)
转载于:https://www.cnblogs.com/wangdetian168/archive/2009/03/23/lianhexiugaishuju.html