declare @table varchar(20)
set @table='準入居者入替'
declare @SQL Nvarchar(2000)
declare @total int
set @SQL='select @total=count(*) from ' +@table + ' select @total'
exec sp_executesql @sql,N'@total int out',@total out
print @total
set @table='準入居者入替'
declare @SQL Nvarchar(2000)
declare @total int
set @SQL='select @total=count(*) from ' +@table + ' select @total'
exec sp_executesql @sql,N'@total int out',@total out
print @total