CREATE PROCEDURE testCount(@szTabName varchar(100))
as
declare @iRecCount int
declare @szSelSql nvarchar(1000)
set @szSelSql = 'select @iRecCount=count(*) from ' + @szTabName
execute sp_ExecuteSql @szSelSql,N'@iRecCount int out',@iRecCount output