关于存储过程中有写字段报列名无效的问题！

我是初学者，想把碰到的问题发表一下，以便我们初学者学习！

CREATE  proc SP_PbFYall

 

@pagesize int,
@pageindex int,
@PB_IntDate varchar(50),
@PB_OutDate varchar(50)

as
 declare @str varchar(2000)
 declare @count int
begin
 select @count=count(*)  from  KQ_PB
 set @str='select top '+convert(varchar,@pagesize)+'  pb.ID,pb.RID,ryb.RY_XM,ryb.RY_BM,bm.BMMC,pb.UID,pb.PB_MC,bclx.SXBMC,pb.PB_IntDATE,pb.PCID,pb.SYSDATE
 from KQ_PB as pb, KQ_RYB as ryb,KQ_BCLX as bclx,KQ_BM as bm  where pb.RID=ryb.ID and pb.PB_MC=bclx.ID and ryb.RY_BM=bm.BMID and pb.PB_IntDate>="'+@PB_IntDate+'"
 and pb.PB_IntDate<="