34,594
社区成员
发帖
与我相关
我的任务
分享
CREATE procedure xs_gzxx
@TableName varchar(30)
as
if object_id('tempdb..#t') is not null drop table #t
create table #t(zts int,yts int,wts int)
declare @sql nvarchar(max)
select @sql='insert #t(zts) select (select count(1) from '+@TableName+');
update #t set yts=(select count(1) from '+@TableName+' where rgl>0);
update #t set wts=(select count(1) from '+@TableName+' where rgl=0);'
exec(@sql)
select * from #t
go