insert dbdo.tcurrentpaging (content) select cast(truck as varchar(9))+' '+owner_name+' '+type+' '+
cast(weight as varchar(2)+' '+cast(length as varchar(2))+' '+telephone+' 'source+' '+destination+' '+CONVERT(varchar(10),publicize_time,120)+' '
cast(period as varchar(2))+' '+re
cast(weight as varchar(2)+' '+cast(length as varchar(2))+' '+telephone+' 'source+' '+destination+' '+CONVERT(varchar(10),publicize_time,120)+' '
cast(period as varchar(2))+' '+re
哦,还有,执行以上要求的同时要将12345插入dbo.tcurrentpaging的pagingcode字段中,
将0插入dbo.tcurrentpaging的ispaged字段中,大侠帮帮忙啊!!万分感谢!!!
cast(weight as varchar(2)+' '+cast(length as varchar(2))+' '+telephone+' 'source+' '+destination+' '+CONVERT(varchar(10),publicize_time,120)+' '
cast(period as varchar(2))+' '+re,0
cast(weight as varchar(2)+' '+cast(length as varchar(2))+' '+telephone+' 'source+' '+destination+' '+CONVERT(varchar(10),publicize_time,120)+' '
cast(period as varchar(2))+' '+re,0 from dbo.truck_db