跨库连表更新

update t1 set t1.imgsrc=REPLACE(t2.IMGSRC,'http://www.cnblogs.com/','http://admin.ebook.91.com/')
from PandaBulkShopProduct t1 inner join ebookdb.dbo.Books t2 on (t1.resid=t2.bookid) AND t1.BulkID=11

 

 

update t1 set t1.downloadurl=REPLACE(t2.FilePath,'http://www.cnblogs.com/Upload/','http://down.ebook.91.com/mag/')
from PandaBulkShopProduct t1 inner join ebookdb.dbo.Books t2 on (t1.resid=t2.bookid) AND t1.BulkID=11 AND t1.level=1