1.--------->
////////////////////////////////////////////////////////////////////////////
///////////////
select
rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000) as
varchar(8000)), char(30), ''), char(13), '')) as NewsContent,
A.NewsID,A.NewsTitle
from News_Content A
where A.NewsID in
(select B.NewsID from News_Second_Class_Index_AE B
where B.NewsID in
( select C.NewsID from News_Keyword_Group_Index_6 C
where C.KeyWordID='11'))
////////////////////////////////////////////////////////////////////////////
//////////////////
select top 100 rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000) as
varchar(8000)), char(30), ''), char(13), ''))
as NewsContent,A.NewsID,A.NewsTitle From News_Content A
inner join News_Second_Class_Index_AE b on A.NewsID = B.NewsID
inner join News_Keyword_Group_Index_6 C on B.NewsID = C.NewsID
where C.KeyWordID = '11' order by A.NewsID desc
/////////////// select rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000) as varchar(8000)), char(30), ''), char(13), '')) as NewsContent, A.NewsID,A.NewsTitle from News_Content A where A.NewsID in (select B.NewsID from News_Second_Class_Index_AE B where B.NewsID in ( select C.NewsID from News_Keyword_Group_Index_6 C where C.KeyWordID='11'))
select top 100 rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000)
as
varchar(8000)), char(30), ''), char(13), '')) as NewsContent,A.NewsID,A.NewsTitle From News_Content A inner join News_Second_Class_Index_AE b on A.NewsID = B.NewsID inner join News_Keyword_Group_Index_6 C on B.NewsID = C.NewsID where C.KeyWordID = '11' order by A.NewsID desc
///////////////
select
rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000) as
varchar(8000)), char(30), ''), char(13), '')) as NewsContent,
A.NewsID,A.NewsTitle
from News_Content A
where A.NewsID in
(select B.NewsID from News_Second_Class_Index_AE B
where B.NewsID in
( select C.NewsID from News_Keyword_Group_Index_6 C
where C.KeyWordID='11'))
select top 100 rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000)
as
varchar(8000)), char(30), ''), char(13), ''))
as NewsContent,A.NewsID,A.NewsTitle From News_Content A
inner join News_Second_Class_Index_AE b on A.NewsID = B.NewsID
inner join News_Keyword_Group_Index_6 C on B.NewsID = C.NewsID
where C.KeyWordID = '11' order by A.NewsID desc
/////////////// select rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000) as varchar(8000)), char(30), ''), char(13), '')) as NewsContent, A.NewsID,A.NewsTitle from News_Content A where A.NewsID in (select B.NewsID from News_Second_Class_Index_AE B where B.NewsID in ( select C.NewsID from News_Keyword_Group_Index_6 C where C.KeyWordID='11'))
select top 100 rtrim(Replace(Replace(cast(substring(A.NewsContent,0,8000)
as
varchar(8000)), char(30), ''), char(13), '')) as NewsContent,A.NewsID,A.NewsTitle From News_Content A inner join News_Second_Class_Index_AE b on A.NewsID = B.NewsID inner join News_Keyword_Group_Index_6 C on B.NewsID = C.NewsID where C.KeyWordID = '11' order by A.NewsID desc