CREATE PROCEDURE [dbo].[www]
@tbname varchar(200)
AS
declare @num int
declare @sql nvarchar(2000)
set @sql='select @num=select count (*)from'+@tbname)
exec sp_executesql @sql,'N'@num int output',@num out
print @num
GO
CREATE PROCEDURE [dbo].[www]
@tbname varchar(200)
AS
declare @num int
set @ss=N'select @num = count(*) from '+@tbname
exec sp_executesql @ss ,N'@num int output',@num output
print @num
CREATE PROCEDURE [dbo].[www]
@tbname varchar(200),
@num int output
AS
declare @sql nvarchar(2000)
set @sql='select @num=select count (*) from'+@tbname
exec sp_executesql @sql,N'@num int output',@num out
GO
--调用
declare @num int
exec www 'test',@num out
select @num as 结果
declare @sql nvarchar(300)
declare @parminfo nvarchar(100)
declare @cnt int
set @sql=N'select @cnt=count(*) from '+@tb_name
set @parminfo=N'@cnt int output'
exec SP_EXECUTESQL @sql,@parminfo, @cnt OUTPUT
return @cnt
Create Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end