Skip to content

Instantly share code, notes, and snippets.

@mukasc
Created June 12, 2020 19:41
Show Gist options
  • Save mukasc/d4bbaed243ea504032f75c8096f5ec4c to your computer and use it in GitHub Desktop.
Save mukasc/d4bbaed243ea504032f75c8096f5ec4c to your computer and use it in GitHub Desktop.
USE gx_kb_atual
DECLARE @tabela VARCHAR(500) = 'RHF_ColabIntermitenteItem';
DECLARE @sql NVARCHAR(4000);
SELECT @sql = comandosql FROM DELSOFTX_TABELA(@tabela)
USE fanavid
EXEC(@sql)
* CAMPOS
USE gx_kb_atual
DECLARE @coluna VARCHAR(500) = 'RHF_COLABINTERCALCULADO';
DECLARE @sql NVARCHAR(4000);
SELECT @sql = comandosql FROM DELSOFTX_ADDCAMPO(@coluna)
USE fanavid
EXEC(@sql)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment