set nocount on declare @RecordCount int,@sql nvarchar(1000) set @sql='select @RecordCount=count (id) from news '+@where exec sp_executesql @sql,N'@RecordCount int output',@RecordCount output
N'@RecordCount int output,@RecordCount output 是什么意思 ?
请参考sp_executesql的联机帮助。 declare @RecordCount int, @sql nvarchar(4000) set @sql='select @RecordCount=count (id) from news '+@where exec sp_executesql @sql,N'@RecordCount int output',@RecordCount output select @RecordCount
declare @RecordCount int,@sql nvarchar(1000)
set @sql='select @RecordCount=count (id) from news '+@where
exec sp_executesql @sql,N'@RecordCount int output',@RecordCount output
declare @RecordCount int,
@sql nvarchar(4000)
set @sql='select @RecordCount=count (id) from news '+@where
exec sp_executesql @sql,N'@RecordCount int output',@RecordCount output
select @RecordCount