1 insert into [databasename].[dbo].[news_sorts](newsid,newsday,newsline,sortname,newsclick,url,imgpath,typeid)
select newsid,newsday,newsline,sortname,newsclick,url,imgpath,typeid
from [databasename_old].[dbo].[news_sorts]
2select top 100 * from dbo.news_sorts inner join dbo.news_title
on dbo.news_title.newsid=dbo.news_sorts.newsid
update dbo.news_sorts set news_sorts.newsline =news_title.newsline
from dbo.news_title inner join dbo.news_sorts
on dbo.news_title.newsid=dbo.news_sorts.newsid where dbo.news_title.newsid=10107658