CREATE PROC proc_countrowstable
as
begin
set nocount On;
Declare @tbName nvarchar(100)
Declare CountRowsTable Cursor For SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' ORDER BY TABLE_SCHEMA, TABLE_NAME
Open CountRowsTable
fetch CountRowsTable
into @tbName
while @@fetch_status=0
begin
begin try
Declare @Query nvarchar(4000),@CursorQuery varchar(4000), @valResult varchar(8000),@SaltoLinea nvarchar(4000)
set @Query='Select Table_name +'+ char(39) +' RowCout: '+ char(39) +'+ cast((select count(*) from '+ @tbname +') as nvarchar(4000)) as valResult from (
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='+char(39)+'BASE TABLE'+ char(39)+') Tablas
where Table_name='+ char(39)+@tbname+char(39)
set @CursorQuery='Declare CursorQuery CURSOR FOR '+@Query
exec(@CursorQuery)
--exec(@Query)
Open CursorQuery
fetch CursorQuery
into @ValResult
print @ValResult
set @SaltoLinea=(SELECT REPLICATE('-',LEN(@ValResult)))
print @SaltoLinea
close CursorQuery
deallocate CursorQuery
End try
begin catch
SELECT ERROR_NUMBER() AS ErrorNumber,
ERROR_MESSAGE() AS ErrorMessage;
end catch
fetch CountRowsTable
into @tbName
end
close CountRowsTable
Deallocate CountRowsTable
end
Comentarios sobre la versión: Versión 1 (7)
muchas gracias
YO STOY ESTUDIANDO ING INFORMATICA EN PARAGUAY Y ME GUSTA EL DESARROLLO DE SISTEMA OHALA ME PUEDAS AYUDAR PARA MAS ADELANTE AMIGO
Oracle-SQL-PLSQL s1914... plis ... me urge!!
Saludos
Por ejemplo tabla -> Comtabilidad.Libros
SELECT sysobjects.Name, sysindexes.Rows
FROM sysobjects
INNER JOIN sysindexes ON sysobjects.id = sysindexes.id
WHERE type = 'U' AND sysindexes.IndId < 2
ORDER BY sysobjects.Name