how can I count the row number in a virtual table that is temporarily created in the stored procedure

Question

I have stored procedure like this

create store procedure onetimeprocessing  
as
begin
declare @input_data (id int,title varchar(400),topic varchar(400))
insert into @input_data
select id,title,topic from dB

I just want to count number of records in the virtual table @input_data

How should I get the count.Please help me Thanks in Advance

Answer 1

select count(*) from @input_data

or after the insert

select @@rowcount

Answer 2

Why not just have this?

create store procedure onetimeprocessing  
as
begin
select COUNT(*) as TheCount from dB

Edit

I'm having difficulty understanding why other folk would suggest to load @inputdata first, then count from that. or return an extra result set with @@ROWCOUNT...

Answer 3

Its available in @@ROWCOUNT:

declare @input_data table (id int,title varchar(400),topic varchar(400))
insert into @input_data select ....

SELECT @@ROWCOUNT