SELECT 'FACTURASVENTA' AS tabla, COUNT(*) AS n, MIN(FECHA) AS minf, MAX(FECHA) AS maxf FROM FACTURASVENTA UNION ALL SELECT 'FACTURASCOMPRA', COUNT(*), MIN(FECHA), MAX(FECHA) FROM FACTURASCOMPRA
| tabla | n | minf | maxf |
|---|---|---|---|
| FACTURASVENTA | 7504519 | 2014-11-12 00:00:00.000 | 2026-11-21 00:00:00.000 |
| FACTURASCOMPRA | 370791 | 2014-01-01 00:00:00.000 | 2026-11-20 00:00:00.000 |
2 filas
SET NOCOUNT ON;
IF OBJECT_ID('tempdb..#r') IS NOT NULL DROP TABLE #r;
CREATE TABLE #r (basedatos sysname, apuntes int, minf datetime, maxf datetime);
DECLARE @db sysname, @sql nvarchar(max);
DECLARE c CURSOR FOR
SELECT name FROM sys.databases WHERE database_id > 4 AND state = 0;
OPEN c; FETCH NEXT FROM c INTO @db;
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRY
SET @sql = 'INSERT INTO #r SELECT ''' + @db + ''', COUNT(*), MIN(FECHA), MAX(FECHA) FROM [' + @db + '].dbo.DIARIOAPUNTES';
EXEC sp_executesql @sql;
END TRY BEGIN CATCH END CATCH
FETCH NEXT FROM c INTO @db;
END
CLOSE c; DEALLOCATE c;
SELECT basedatos, apuntes, minf, maxf FROM #r ORDER BY maxf DESC;| basedatos | apuntes | minf | maxf |
|---|---|---|---|
| C2021030 | 162586 | 2021-01-01 00:00:00.000 | 3025-01-10 00:00:00.000 |
| C2023001 | 355646 | 2002-10-16 00:00:00.000 | 2525-04-01 00:00:00.000 |
| C2023041 | 595534 | 2004-10-31 00:00:00.000 | 2525-03-31 00:00:00.000 |
| CSANTALO | 69867 | 2014-01-01 00:00:00.000 | 2216-02-19 00:00:00.000 |
| PLAZA | 86521 | 2014-08-19 00:00:00.000 | 2216-02-19 00:00:00.000 |
| CBONANOVA | 56043 | 2016-01-01 00:00:00.000 | 2188-10-31 00:00:00.000 |
| CMASQCARNE | 21118 | 2016-01-02 00:00:00.000 | 2188-10-31 00:00:00.000 |
| CMUNTANER | 33513 | 2016-01-01 00:00:00.000 | 2108-03-22 00:00:00.000 |
| C2023047 | 29808 | 2023-01-01 00:00:00.000 | 2025-12-31 00:00:00.000 |
| C2022054 | 2650 | 2022-01-01 00:00:00.000 | 2024-04-26 00:00:00.000 |
| C2022041 | 317707 | 2022-01-01 00:00:00.000 | 2022-12-31 00:00:00.000 |
| C2022047 | 69986 | 2022-01-01 00:00:00.000 | 2022-12-31 00:00:00.000 |
| C2022001 | 181520 | 2022-01-01 00:00:00.000 | 2022-12-31 00:00:00.000 |
| C2022004 | 236 | 2022-01-01 00:00:00.000 | 2022-10-20 00:00:00.000 |
| C2020041 | 208813 | 2020-01-01 00:00:00.000 | 2022-09-30 00:00:00.000 |
| C2021041 | 366063 | 2021-01-01 00:00:00.000 | 2021-12-31 00:00:00.000 |
| C2021047 | 74409 | 2021-01-01 00:00:00.000 | 2021-12-31 00:00:00.000 |
| C20210542021 | 182 | 2021-06-30 00:00:00.000 | 2021-12-31 00:00:00.000 |
| C2021001 | 215408 | 2021-01-01 00:00:00.000 | 2021-12-31 00:00:00.000 |
| C2021004 | 70408 | 2021-01-01 00:00:00.000 | 2021-12-31 00:00:00.000 |
| CASATIO | 221 | 2020-11-25 00:00:00.000 | 2021-02-05 00:00:00.000 |
| C2020047 | 58552 | 2020-01-01 00:00:00.000 | 2020-12-31 00:00:00.000 |
| C2020001 | 196327 | 2020-01-01 00:00:00.000 | 2020-12-31 00:00:00.000 |
| C2020004 | 114329 | 2020-01-01 00:00:00.000 | 2020-12-31 00:00:00.000 |
| C2020030 | 17223 | 2020-01-01 00:00:00.000 | 2020-12-31 00:00:00.000 |
| C2019001 | 199453 | 2019-01-01 00:00:00.000 | 2019-12-31 00:00:00.000 |
| C2019004 | 109879 | 2019-01-01 00:00:00.000 | 2019-12-31 00:00:00.000 |
| C2019030 | 20774 | 2019-01-01 00:00:00.000 | 2019-12-31 00:00:00.000 |
| C2019041 | 159436 | 2019-01-01 00:00:00.000 | 2019-12-31 00:00:00.000 |
| C2019047 | 62263 | 2019-01-01 00:00:00.000 | 2019-12-31 00:00:00.000 |
| TAMBOARCE2016 | 3412 | 2016-04-06 00:00:00.000 | 2019-11-22 00:00:00.000 |
| C2018001 | 197853 | 2018-01-01 00:00:00.000 | 2018-12-31 00:00:00.000 |
| C2018004 | 91935 | 2011-12-15 00:00:00.000 | 2018-12-31 00:00:00.000 |
| C2018030 | 17537 | 2018-01-01 00:00:00.000 | 2018-12-31 00:00:00.000 |
| C2018041 | 161263 | 2018-01-01 00:00:00.000 | 2018-12-31 00:00:00.000 |
| C2018047 | 96573 | 2018-01-01 00:00:00.000 | 2018-12-31 00:00:00.000 |
| C2018002 | 928 | 2018-01-01 00:00:00.000 | 2018-07-05 00:00:00.000 |
| CEDGAR2018 | 262 | 2017-12-28 00:00:00.000 | 2018-06-20 00:00:00.000 |
| ROSAESTRELLA | 634 | 2017-09-13 00:00:00.000 | 2018-04-01 00:00:00.000 |
| CTAMBOSL_2016 | 59224 | 2017-01-02 00:00:00.000 | 2018-01-31 00:00:00.000 |
| CKCH_INVERSORY_2017 | 87082 | 2017-01-14 00:00:00.000 | 2017-12-31 00:00:00.000 |
| C2017001 | 216131 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |
| C2017002 | 17249 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |
| C2017004 | 90596 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |
| C2017030 | 12696 | 2017-01-01 00:00:00.000 | 2017-12-31 00:00:00.000 |
| CPRUEBAS_KACHA_2014 | 113 | 2014-08-19 00:00:00.000 | 2017-09-14 00:00:00.000 |
| CPADUA | 56 | 2016-01-26 00:00:00.000 | 2017-04-21 00:00:00.000 |
| CFRANQUICIAS | 393 | 2016-09-21 00:00:00.000 | 2017-01-12 00:00:00.000 |
| CKUMATO2016 | 3543 | 2016-01-01 00:00:00.000 | 2016-12-31 00:00:00.000 |
| CBONA2016 | 74366 | 2016-01-01 00:00:00.000 | 2016-12-31 00:00:00.000 |
| C2016001 | 164989 | 2016-01-01 00:00:00.000 | 2016-12-31 00:00:00.000 |
| C2016002 | 7406 | 2016-01-01 00:00:00.000 | 2016-12-31 00:00:00.000 |
| C2015001 | 13350 | 2015-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |
| C2015002 | 4 | 2015-12-31 00:00:00.000 | 2015-12-31 00:00:00.000 |
| CDYLAN_2015 | 888 | 2015-09-13 00:00:00.000 | 2015-12-31 00:00:00.000 |
| CKACHA_2014 | 690 | 2014-08-19 00:00:00.000 | 2014-12-31 00:00:00.000 |
| CREDLY2016 | 0 | ||
| Consolidado_kch | 0 | ||
| CDYLANNOU2017 | 0 | ||
| CDYLANNOVA20212021 | 0 | ||
| OBRADOR | 0 | ||
| CTAMBOARCE | 0 | ||
| CTAMBOSL | 0 | ||
| C_TAMBO_SL | 0 | ||
| C1KUMATO2016 | 0 | ||
| C2017047 | 0 | ||
| CBONA | 0 |
67 filas
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME IN ('NOMINAS','NOMINASENLACECONTA')
ORDER BY TABLE_NAME, ORDINAL_POSITION| TABLE_NAME | COLUMN_NAME | DATA_TYPE |
|---|---|---|
| NOMINAS | CODEMPLEADO | int |
| NOMINAS | MES | int |
| NOMINAS | ANYO | int |
| NOMINAS | TOTAL_DEVENGADO | float |
| NOMINAS | RETIRPF | float |
| NOMINAS | SSEMPLEADO | float |
| NOMINAS | SSEMPRESA | float |
| NOMINAS | CONTABILIZADO | bit |
| NOMINAS | ENLACE_EMPRESA | int |
| NOMINAS | ENLACE_EJERCICIO | int |
| NOMINAS | ENLACE_ASIENTO | int |
| NOMINAS | ENLACE_USUARIO | nvarchar |
| NOMINASENLACECONTA | MES | int |
| NOMINASENLACECONTA | ANYO | int |
| NOMINASENLACECONTA | ENLACE_EMPRESA | int |
| NOMINASENLACECONTA | ENLACE_EJERCICIO | int |
| NOMINASENLACECONTA | ENLACE_ASIENTO | int |
| NOMINASENLACECONTA | ENLACE_USUARIO | nvarchar |
18 filas
Fin. Recuerda borrar diag_contab4.php al terminar.