AlTER PROCEDURE TryAgain

@ReturnValue int output

AS

declare @aa nvarchar(),

        @ForumID int,

        @count int,

        @TotalRecords int

BEGIN

set @ForumID =

set @aa=N'select  @ReturnValue=count(1) from TC_BBS_Topics tc_bt where ForumID='+convert(varchar(),@ForumID)

EXEC sp_executesql @aa,N'@ReturnValue int output ',@ReturnValue   output

END

AlTER PROCEDURE TryAgain

@ReturnValue int output

AS

declare @aa nvarchar(),

        @ForumID int,

        @count int

BEGIN

set @ForumID =    ;

set @aa=N'select  @count=count(1) from TC_BBS_Topics tc_bt where ForumID=@id';

EXEC sp_executesql @aa,N'@id int,@count int output ',@id = @ForumID, @count=@ReturnValue   output;

END