I'm trying to run the DDL command below that creates the table I need, but even not returning error the table is not created, would anyone have any idea where I'm going wrong?
public const string scriptCriacao = " if exists(select * from sys....
Well, I want you to choose the data to display between the dates he chooses. I tried everything but I still could not.
In other words, I want to filter between dates, but the user has to choose them. I already managed with an SQL command, but...
I have the following query:
SELECT distinct CAPA.COD_HOLDING,
CAPA.COD_MATRIZ,
CAPA.COD_FILIAL,
CAPA.ID_NF_ENTRADA,
CAPA.NUM_NF,
CAPA.DT_ENTRADA,
CAPA.DT_EMISSAO,
CAPA.COD_CLIFOR,
CAPA.COD_UF,
CAPA.CGC_CPF,...
I'm doubtful in the date format that ODBC runs. I tried every way and nothing. This Query performs normal if I enter only the code, but when I want to insert dates it does not execute. I believe it's because of the format. Can someone help me?...
I need to delete multiple table data in different SGDB types, but I do not know how to do this in a practical way.
I need to keep 10 records in the tables and I need to delete all the remaining ones, but I can not do this with the command:...
I have a field in the bank of type "char", I am returning the dates this way:
select
CONVERT(VARCHAR(20),HORA_FECHAMENTO) as HORA_FECHAMENTO,
CONVERT(VARCHAR(20), DATEADD(hour, +0, getdate()), 120) as HORA_ATUAL
from TB_ESTRACAO
wh...
I have a database of a client that has some unmasked data for use on my system which is the NCM ;
The same has 8 digits (eg 0000.00.00), but the same in my system is unmasked "00000000" I need to simply put the points 4.2,2 but I am not...
To edit a report, I need to get everything and turn it into an Array.
I can not use UPDATE because the user can add more rows, having to add.
In this way, I thought of first to delete the data that codeReport = '$ codeReport' and then give...