--没测试过, 应该差不多.
create proc record_count(@TableName varchar(100))
as
declare @str nvarchar(400), @count int
set @str='select @count=count(1) from '+@tablename
exec sp_excutesql @str, N'@count int', @count
go
create proc record_count(@TableName varchar(100))
as
declare @str nvarchar(400), @count int
set @str='select @count=count(1) from '+@tablename
exec sp_excutesql @str, N'@count int', @count
go
create proc record_count
(
@TableName varchar(100),
@count int output
)
as
declare @str nvarchar(400)
set @str='select @count=count(1) from '+@tablename
exec sp_excutesql @str, N'@count int output', @count output
go