--如需要请进行数据类型相应的转换。
update a set picname=b.smalltype+c.cartype_id
from pic a,table1 b,table2 c
where a.smalltype=b.id and a.cartype_id=c.id
and pc_id in(select top 50 pic_id from pic where (picname='' or picname is null) and cartype_id is not null order by pic_id
)
update a set picname=b.smalltype+c.cartype_id
from pic a,table1 b,table2 c
where a.smalltype=b.id and a.cartype_id=c.id
and pc_id in(select top 50 pic_id from pic where (picname='' or picname is null) and cartype_id is not null order by pic_id
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货