CREATE proc datacount
@tablename nvarchar(10)
AS
begin
declare @max int,@sql varchar(99)
select @sql='select * from '+@tablename
exec(@sql)
select @max = @@rowcount
select @max
end
@tablename nvarchar(10)
AS
begin
declare @max int,@sql varchar(99)
select @sql='select * from '+@tablename
exec(@sql)
select @max = @@rowcount
select @max
end
@tablename nvarchar(10)
AS
declare @str varchar(500)set @str='select * from '+@tablename
exec (@str)
go