为什么得不到想要的结果,麻烦帮我看看!!!

[zkfhubei]

declare @ChengRec varchar(500)

declare ChengRecFetch scroll cursor for
select dates,types,remark from farec where gzbh = '20664'
--声明变量
declare @Fdates datetime
declare @Ftypes varchar(10)
declare @Fremark varchar(50)
--开始游标
open ChengRecFetch
fetch ChengRecFetch into @Fdates,@Ftypes,@Fremark
while @@Fetch_status = 0
begin
select @ChengRec = @ChengRec + Convert(varchar,@Fdates) + @Ftypes + @Fremark
fetch ChengRecFetch into @Fdates,@Ftypes,@Fremark
end
close ChengRecfetch
deallocate ChengRecfetch

print @ChengRec

select @ChengRec = @ChengRec + Convert(varchar,@Fdates) + @Ftypes + @Fremark这句好象有问题!

[zkfhubei]

但是以上语句在MSQL中是通过了语法检查的!

[cxingh]

select @ChengRec = rtrim(@ChengRec) + Convert(varchar(10),@Fdates,101) + rtrim(@Ftypes) + rtrim(@Fremark)

[zkfhubei]

楼上的兄弟好象不行呀!还是打印不出任何内容!
但是用select @chengRec = Convert(varchar,@Fdates) + @Ftypes + @Fremark
可以打印最后一条记录!

[Andy__Huang]

set @ChengRec =''
然後

select @ChengRec = @ChengRec + Convert(varchar,@Fdates，120) + @Ftypes + @Fremark

因為@ChengRec 声明後初值為null
null和其他值相加都為null,所以打印出來是空的

[zkfhubei]

楼上的兄弟,果然厉害!
就是这个原因!谢了!