我想把select * from AC_Article_KeyWords_Relation语句查询出来的结果放在一个数组A中
把select KeyWords=SUBSTRING(b.KeyWords,number,CHARINDEX(',',b.KeyWords+',',number+1)-number),ArticleId
from master..spt_values a join AC_Article b on a.number between 1 and LEN(b.KeyWords)
where CHARINDEX(',',','+b.KeyWords,number) = number AND type = 'P' order by KeyWords
查询出来的结果放在一个数组B中比较两个数组,去除掉两个数组中共有的数据,
把数组A中剩下的数据添加到数据库中,把数据B中的数据从数据库中删除,求高人指点怎么做,希望可以给出例子,谢谢,分不多,求助!!!
--文章表
create table AC_Article
(
ArticleId int primary key identity(1,1),
KeyWords varchar(100)
)
insert into AC_Article
select '联合卡车,卡车,商用车,' union
select '东风,卡车' union
select '商用车,卡车,' union
select '卡车,'--查询关键字,添加到文章--关键词联系表(所有文章)
if not exists(select * from sysobjects where name='AC_Article_KeyWords_Relation')
begin
create table [AC_Article_KeyWords_Relation]
(
KeyWords varchar(100),
ArticleId int
)
end
delete from [AC_Article_KeyWords_Relation]
insert [AC_Article_KeyWords_Relation]
select KeyWords=SUBSTRING(b.KeyWords,number,CHARINDEX(',',b.KeyWords+',',number+1)-number),ArticleId
from master..spt_values a join AC_Article b on a.number between 1 and LEN(b.KeyWords)
where CHARINDEX(',',','+b.KeyWords,number) = number AND type = 'P' order by KeyWords--根据AC_Article_KeyWords_Relation表里的数据得到关键,文章数量的数据(有效文章)
if not exists(select * from sysobjects where name='AC_KeyWords_ArticleCount')
begin
create table [AC_KeyWords_ArticleCount]
(
KeyWords varchar(100),
ArticleCount int
)
end
delete from [ac_keywords_articleCount]
insert into [AC_KeyWords_ArticleCount]
select aakr.KeyWords,count(aakr.articleId) as ArticleCount
from [AC_Article_KeyWords_Relation] as aakr,[AC_Article] as aa
where aakr.articleId=aa.ArticleId and IsEnable=1 and IsPublish=1
group by aakr.KeyWords
order by count(aakr.articleId) desc,aakr.KeyWords desc
把select KeyWords=SUBSTRING(b.KeyWords,number,CHARINDEX(',',b.KeyWords+',',number+1)-number),ArticleId
from master..spt_values a join AC_Article b on a.number between 1 and LEN(b.KeyWords)
where CHARINDEX(',',','+b.KeyWords,number) = number AND type = 'P' order by KeyWords
查询出来的结果放在一个数组B中比较两个数组,去除掉两个数组中共有的数据,
把数组A中剩下的数据添加到数据库中,把数据B中的数据从数据库中删除,求高人指点怎么做,希望可以给出例子,谢谢,分不多,求助!!!
--文章表
create table AC_Article
(
ArticleId int primary key identity(1,1),
KeyWords varchar(100)
)
insert into AC_Article
select '联合卡车,卡车,商用车,' union
select '东风,卡车' union
select '商用车,卡车,' union
select '卡车,'--查询关键字,添加到文章--关键词联系表(所有文章)
if not exists(select * from sysobjects where name='AC_Article_KeyWords_Relation')
begin
create table [AC_Article_KeyWords_Relation]
(
KeyWords varchar(100),
ArticleId int
)
end
delete from [AC_Article_KeyWords_Relation]
insert [AC_Article_KeyWords_Relation]
select KeyWords=SUBSTRING(b.KeyWords,number,CHARINDEX(',',b.KeyWords+',',number+1)-number),ArticleId
from master..spt_values a join AC_Article b on a.number between 1 and LEN(b.KeyWords)
where CHARINDEX(',',','+b.KeyWords,number) = number AND type = 'P' order by KeyWords--根据AC_Article_KeyWords_Relation表里的数据得到关键,文章数量的数据(有效文章)
if not exists(select * from sysobjects where name='AC_KeyWords_ArticleCount')
begin
create table [AC_KeyWords_ArticleCount]
(
KeyWords varchar(100),
ArticleCount int
)
end
delete from [ac_keywords_articleCount]
insert into [AC_KeyWords_ArticleCount]
select aakr.KeyWords,count(aakr.articleId) as ArticleCount
from [AC_Article_KeyWords_Relation] as aakr,[AC_Article] as aa
where aakr.articleId=aa.ArticleId and IsEnable=1 and IsPublish=1
group by aakr.KeyWords
order by count(aakr.articleId) desc,aakr.KeyWords desc
解决方案 »
- 使用PrintSystemJobInfo类 如何实时判断打印完成
- VS2010 Professional版本有没有Profiler
- 这是什么意思
- 没盘怎么安装IIS的frontpage扩展?
- javascript有没有键值对类似hashtable?
- 呼叫中心的建立采用哪一种模式比较好?希望各位各抒已见呀!
- 请教CodeDom的问题
- 哪位高手请帮我,用C#编写一个类似于腾讯微博中的推荐好友添加的程序。给我个概述也行!我好找到更贴近的网上资源!先谢谢了!
- c#在pdf加入图片
- 如何实现DataGrid用户自定义分页大小?
- c#报错 Object reference not set to an instance of an object.
- 共厂方法模式的优点,有何用处?求教~~~~
select * from A intersect select * from B(前表和后表中都有记录)
2,定义两个标志数组,分别对应A,B数组的每一个元素。
3,一个二层循环将标志数组置位,然后根据标志位的情况删除……
在循环表a和表b的数据判断表b中有重复的删除掉,,就可以了啊,,
既然思路清晰了,做起来就简单了啊,,
如果A中有的数据在B中不存在,那么从数据库中删除A中的数据
如果B中有的数据中在A中不存在,那么将B中的数据添加到数据库中
我一直没做过数组,所以比较生疏,现在又急着要效果,所以求助了,希望各位可以帮帮我
删除数据的语句:delete from AC_Article_KeyWords_Relation where KeyWords=@KeyWords and ArticleId=@ArticleId
添加数据的语句:insert into AC_Article_KeyWords_Relation values(@KeyWords,@ArticleId)
学习中