修改SQL语句,以前老以为数据库自动做好了优化工作,其实不然,在修改后的SQL语句,可以很快实现.
'tSql="select ArticleUrl,Title,NewsTime,Source from mynews where ID in (select distinct urlID from UrlWord where word='"+ sKey +"');"
tSql=" select ArticleUrl,Title,NewsTime ,Source from mynews where Title like '%" + sKey +"%' Union All select ArticleUrl,Title,NewsTime,Source from mynews where ID in (select distinct urlID from UrlWord where word='"+ sKey +"');"
利用游标来增加数据到mynews表中
declare newsie_cur cursor
for
select ArticleUrl,Title,NewsTime from newsie
open newsie_cur
declare @ArticleUrl nvarchar(255),@Title nvarchar(255),@NewsTime datetime
fetch next from newsie_cur into @ArticleUrl,@Title,@NewsTime
while(@@fetch_status=0)
begin
fetch next from newsie_cur into @ArticleUrl,@Title,@NewsTime
insert into mynews(ArticleUrl,Title,NewsTime,Source) values( @ArticleUrl,@Title,@NewsTime,'信息工程学院')
end
close news_cur
