Dynamic Table Name (was Please Help !! SQL)

Hi--

I am new to T-SQL i got this code from some website but its not working can anyone let me know why
@cur_tab_name varchar(30) is not decleared while i have decleared
I want to use this for dynamic name of the table.

Thanks.






create table temp_tab
(
tab_name varchar(30),
no_of_rows INTEGER,
)

DECLARE
curREVIEW

CURSOR FOR
select name
from sysobjects
where xtype = 'U'


DECLARE @cur_tab_name varchar(30)

OPEN curREVIEW

FETCH curREVIEW INTO @cur_tab_name

WHILE (@@FETCH_STATUS =0)
BEGIN
DECLARE @count integer

select @count = count(*) from @cur_tab_name
INSERT INTO temp_tab
(@cur_tab_name, @count)

FETCH curREVIEW INTO @cur_tab_name

END

CLOSE curREVIEW

DEALLOCATE curREVIEW