sql查询的奇怪问题？？？？

2009-10-20 09:34:39 75 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

深入解析V4L2框架与高通KMD在Camera驱动中的协同设计本文深入解析了V4L2框架与高通KMD在Camera驱动中的协同设计。V4L2作为Linux内核标准视频驱动框架，提供了统一的设备抽象与数据流管理；而高通KMD则在其基础上，通过引入CRM等核心模块，构建了一套针对移动平台复杂相机系统的高效内核态驱动架构，实现了硬件配置与执行的解耦与智能调度。阅读详情

真是服了，昨天写了个存储过程，遇到了一个奇怪的问题
我用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
涉及到的表的脚本太长，如果大家测试我把表的脚本也发上来，谢谢帮忙解决！！！

...全文