34,587
社区成员
发帖
与我相关
我的任务
分享
declare @RecordCount int
declare @QueryStr varchar(50)
declare @sql nvarchar(4000)
set @QueryStr='tbl_Schedule'
set @sql='select @a=count(*) from ' + @QueryStr
exec sp_executesql @sql,N'@a int output',@RecordCount output
select @RecordCount
set @a='select @dd=isnull(max('+@bh+'),'''') from tablea where ('+@bh+' like '''+@wh+'%'')'
exec SP_EXECUTESQL @a,N'@dd varchar(50) output ',@dd output
select @dd
EXECUTE (N'SELECT ' + @RecordCount + ' = COUNT(*) FROM ' + @QueryStr)
create table #t(recordcount int)
insert into #t
EXECUTE (N'SELECT COUNT(*) FROM ' + @QueryStr)
select * from #t