SELECT * FROM CADEST WHERE CADPRO = '007.001.001' 
SELECT * FROM CADEST WHERE CADPRO = '007.001.002' 
SELECT * FROM CADEST WHERE CADPRO = '007.001.001' 
SELECT * FROM CADEST WHERE CADPRO = '007.001.002' 
select * from condia_tce where evento='8.13-27' and grupo in (6,7) 
delete from dirf_exceto_desdobro 
select * from config_scpi 
select * from condia_tce
select * from condia_tce where balco like '81231095%' and contrato = '0901/20'
select * from condia_tce where balco like '81231095%'
select * from condia_tce where balco like '8123109%'
select * from condia_tce where balco like '8123109%' and contrato = '0901/20'
select count(codif) from desfor
SELECT * FROM DESFOR
SELECT max(codigo) FROM CONTRATOSADITAMENTO
UPDATE CONFIG_SCPI SET VALOR = 'N' WHERE PARAMETRO = 'CONTR_SEM_SLD';
select * from TS_formaliza
select * from TS_prestacao
select * from TS_certidao
delete from TS_formaliza
select * from TS_certidao
select * from TS_prestacao
delete from TS_formaliza
select * from TS_prestacao
delete from TS_formaliza
select * from TS_certidao
select * from TS_formaliza
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S' 
delete from icadreq where requi = '000484/23' 
delete from requi where requi = '000484/23' 
select * from condia_tce where debit<>cast(debit as numeric(14,2)) or credi<>cast(credi as numeric(14,2)) 
UPDATE SENHA SET TABDEF_EXECUCAO = NULL WHERE TABDEF_EXECUCAO = 'S'; 
select empresa, nome, trava, travadiario from tabempresa
SELECT * FROM PT_CADPAT
SELECT * FROM PT_CADPAT WHERE CODIGO_CPL_PAT = NULL
SELECT * FROM PT_CADPAT WHERE CODIGO_CPL_PAT = 'NULL'
SELECT * FROM PT_CADPAT
SELECT * FROM CONDIA_TCE WHERE NDOC = '7703'
SELECT * FROM CONDIA_TCE WHERE NDOC = '7922'
SELECT * FROM CONDIA_TCE WHERE NDOC = '7922' AND CONTRATO_TIPO IS NOT NULL
SELECT * FROM CONDIA_TCE WHERE NDOC = '32' AND CONTRATO_TIPO IS NOT NULL
SELECT * FROM CONDIA_TCE WHERE NDOC = '32' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '33' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '10457' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '8637' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '8767' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '6609' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '1733' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '9652' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '9653' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '8768' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '8769' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '7864' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '6241' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '6238' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '4645' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM CONDIA_TCE WHERE NDOC = '9654' AND CONTRATO_TIPO IS NOT NULL AND ANO_DOC = 2023
SELECT * FROM DESPES WHERE NEMPG IN (8769,8637,7864,6241,6238,4645, 6609,4982,7703,7922,32,33,10457,8767,8768,4983,4985,1733,9652,9653,9654) AND ANO_RESTO = 2023
SELECT PKEMP, NEMPG, CONTRATO_TIPO FROM DESPES WHERE NEMPG IN (8769,8637,7864,6241,6238,4645, 6609,4982,7703,7922,32,33,10457,8767,8768,4983,4985,1733,9652,9653,9654) AND ANO_RESTO = 2023
SELECT PKEMP, NEMPG, CONTRATO_TIPO FROM DESPES WHERE NEMPG IN (8769,8637,7864,6241, 6238,4645, 6609,4982,7703,7922,32,33,10457,8767,8768,4983,4985,1733,9652,9653,9654) AND ANO_RESTO = 2023
SELECT  * FROM LDO_META
delete  FROM LDO_META