MSSQL语句备份

insert  into MyNews.dbo.news(ArticleTitle,ArticleText) select ArticleTitle,ArticlePureText from newsInfoWangYi where ArticleId between 1 and 20

表复制SELECT * INTO newtable FROM oldtable WHERE ...

用一个表的一列 更新另一个表的一列

UPDATE DataCollection.dbo.Article SET DataCollection.dbo.Article.CKeyWord=ArticleAssist.dbo.finalArticle.CKeyWord  from DataCollection.dbo.Article left  join ArticleAssist.dbo.finalArticle on DataCollection.dbo.Article.ArticleId=ArticleAssist.dbo.finalArticle.ArticleId