sql查询的奇怪问题????
真是服了,昨天写了个存储过程,遇到了一个奇怪的问题
我用select * from RE_NewsColumn_NewsTopics 从表中查询有3条记录,然后我把写的存储过程复制到这个查询分析器下,在查他就变成一条记录了,不知道大家遇到过这种问题没有,是什么原因???
那个存储过程是select * from RE_NewsColumn_NewsTopics
declare @conditions varchar(20),@values varchar(100),@startIndex int,@endIndex int
set @conditions = ''
set @values = ''
set @startIndex = 1
set @endIndex = 1
set nocount on
declare @indextable table(id int identity(1,1),nid int)
set rowcount @endIndex
if(@conditions = '')
begin
insert into @indextable(nid) select TopicsID from NewsTopics order by TopicsID desc
select c.ColumnName as ColumnName,a.TopicsID as TopicsID,a.TopicsKeyWord as TopicsKeyWord,a.Description as Description,a.TopicsName as TopicsName,a.SubDate as SubDate,a.Operator as Operator
into #temp1
from dbo.NewsTopics a
join RE_NewsColumn_NewsTopics b on a.TopicsID=b.TopicsID
join NewsColumn c on b.ColumnID = c.ColumnID
select TopicsName,TopicsID, ColumnName = stuff((select ',' + ColumnName from #temp1 t where TopicsID = #temp1.TopicsID for xml path('')) , 1 , 1 , '')
,TopicsKeyWord,Description,SubDate,Operator
into #temp01
from #temp1
group by TopicsName,TopicsID,TopicsKeyWord,Description,SubDate,Operator
select * from #temp01 a
inner join @indextable t on
a.TopicsID=t.nid
where t.id between @startIndex and @endIndex order by t.id
select * from RE_NewsColumn_NewsTopics
drop table #temp1
drop table #temp01
end
涉及到的表的脚本太长,如果大家测试我把表的脚本也发上来,谢谢帮忙解决!!!