一个关于存储过程的问题（set @sql='select '+cast(@count as varchar)+' = ID from ZH_TeacherTopic'）

[wangwm]

declare @count int
declare @sql varchar(2000)
set @sql='select '+cast(@count as varchar)+' = ID from ZH_TeacherTopic'
exec(@sql)
print @count

请教一下高手们，以上代码怎么在查询分析器中,得不到@count的值，解决立马揭帖，谢谢了啊

[子陌红尘]

declare @count int
declare @sql nvarchar(2000)
set @sql=N'select @count=ID from ZH_TeacherTopic'
exec sp_executesql @sql,N'@count int out',@count out
print @count

[wangwm]

谢谢你libin_ftsafe(子陌红尘)，请问为什么我下面的存储过程不能运行阿

set @RowCount = (@PageNo - 1) * @PageSize + 1
set rowcount @RowCount
SET @sql = N'select @BeginID = ID from ZH_TeacherTopic where '+@sWhere+' order by DTStart desc'
exec sp_executesql @sql,N'@BeginID int out',@BeginID out

set @RowCount = @PageNo * @PageSize
set rowcount @RowCount
SET @sql =N'select @EndID = ID from ZH_TeacherTopic where '+@sWhere+' order by DTStart desc'
exec sp_executesql @sql,N'@EndID int out',@EndID out
print @EndID
set rowcount 0
set nocount off

SET @sql ='select * from ZH_TeacherTopic where '+@sWhere+' and (ID between '+cast(@EndID as varchar)+' and '+cast(@BeginID as varchar)+') order by DTStart desc'
EXEC(@sql)

[子陌红尘]

错误信息？

[wangwm]

已经调试好了，谢谢你，马上结贴，以后有不懂的地方，还请你帮忙