这个存储过程为什么读不出数据啊？郁闷

[IT流渊]

CREATE PROCEDURE PrSerchTag
@tag varchar(20)
AS
declare @id int
declare @tagid int
--declare @bool char(4)
begin
if exists (select tagid from tagtable where tagname like '%'+@tag+'%')
begin

select @tagid = tagid from tagtable where tagname like '%'+@tag+'%'
select @id= rizhiid from rizhitagtable where tagid =@tagid
select rizhiid,yonghuname,rizhititle,substring(rizhicontent,0,200)+'......' as 'rizhicontent',rizhitime,touchnum,yonghuid from rizhiview where rizhiid=@id
end
else
return (0)


end

[CathySun118]

数据库中有相应的记录吗
在查询分析器中执行试试

[OracleRoob]

监测@tagid、@id的值。

在你的Sp中每一步，都加上select @tagid as tagid,@id as id，看看变量值是否正确

[IT流渊]

数据库里相应的记录都有的就是不出来。
select tagid from tagtable where tagname like '%'+@tag+'%'
在查询分析器能查处值来的，是单条运行的。

[OracleRoob]

if exists (select tagid from tagtable where tagname like '%'+@tag+'%')
begin

.....
-->


if exists (select tagid from tagtable where tagname like '%'+@tag+'%')
begin

select 1 --加上这条，执行后看看有没有执行到这句。
.....

[free_pop2k]

select @tagid = tagid from tagtable where tagname like '%'+@tag+'%'
select @id= rizhiid from rizhitagtable where tagid =@tagid

tagid应可能有多个值吧，能这样输给@tagid么？
rizhiid也有可能有多个值的,不能这样给@id输值.

[free_pop2k]

@tagid只能是最后的一个tagid的值
@id也只能是rizhiid的最后一个值

[ojuju10]

@tagid,@id 只读出一个值，建议楼主写成游标

[sunshareforever]

similarly answer below:

HTTP://www.ebigear.com/Fund/PlayNews.php?NewsID=28340&ID=285885

[IT流渊]

对哦，非常感谢大家的帮助，谢谢！怎么就没想到呢....