急！！求SQL 语句！！

[y8722535]

原来语句如下：
declare @ID int
select @ID=TuID from bbsTopic, bbsUsers where Uname = '心酸果冻'
print '心酸国冻发贴数：'
select count(*) from bbsTopic where @ID = TuID

结果：
心酸国冻发贴数：
-----------
1


需要的结果为：
心酸国冻发贴数：1

各位高手帮我把这个给解决吧！

[guyehanxinlei]

print '心酸国冻发贴数： ' +select count(*) from bbsTopic where @ID = TuID

[y8722535]

我用了的 没有用！
服务器: 消息 156，级别 15，状态 1，行 3
在关键字 'select' 附近有语法错误。

[hjj841020]

declare @ID int
select @ID=TuID from bbsTopic, bbsUsers where Uname = '心酸果冻 '
select '心酸国冻发贴数:'+count(*) from bbsTopic where @ID = TuID

[fa_ge]

declare @ID int
select @ID=TuID from bbsTopic, bbsUsers where Uname = '心酸果冻 '

select '心酸国冻发贴数： ' +space(2) + ltrim(count(*)) from bbsTopic where @ID = TuID

[hjj841020]

select '心酸国冻发贴数: '+rtrim(cast(count(*) as varchar(10))) from bbsTopic where @ID = TuID

[hjj841020]

select '心酸国冻发贴数: '+rtrim(cast(count(*) as varchar(10))) from bbsTopic where @ID = TuID

[guyehanxinlei]

declare @ID int
declare @count int
select @ID=TuID from bbsTopic, bbsUsers where Uname = '心酸果冻 '

select @count=count(*) from bbsTopic where @ID = TuID
print '心酸国冻发贴数： ' +cast(@count as varchar(10))

[fa_ge]

楼上，用了rtrim，可以不用cast再转换

[pt1314917]

select '心酸国冻发贴数： ' +count(*) from bbsTopic where @ID = TuID 

[guyehanxinlei]

鶴嘯九天 谢了

[fa_ge]

试一下可不以插入源代码

select * from t

[y8722535]

恩， 谢了。。。

[y8722535]

怎么不能结贴？