RE:Cantidad de registros por tabla
Hola Araceli
Espero te sirva este codigo:
-- Declaro mis variables de uso
DECLARE @MyCursor as cursor,
@TABLENAME VARCHAR(50),
@SQLString NVarchar(300)
SET NOCOUNT ON
-- Creo mi tabla de uso temporal
create table #temporal_tables (nametable varchar(50), regs int)
-- Obtengo los nombres de mis tablas
insert into #temporal_tables
select name,0 from sysobjects where xtype = 'u'
-- Obtengo mi cursor
SET @MyCursor = CURSOR
FOR
SELECT NAMETABLE FROM #temporal_tables
OPEN @MyCursor
-- Entro en Loop
FETCH NEXT FROM @MyCursor INTO @TABLENAME
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @SQLString = N'update #temporal_tables set regs = (select count(*) from '+@TABLENAME+') WHERE nametable = '+char(39)+@TABLENAME+char(39)
exec SP_executesql @SQLString
FETCH NEXT FROM @MyCursor INTO @TABLENAME
CONTINUE
END
-- Veo los resultados
SELECT * FROM #temporal_tables
SET NOCOUNT OFF