Questions tagged as 'sql'

Tagged questions
0
answers

Greek symbol theta inserting in SQL

We have an application here at work where we generate some screens in angularjs and store in database for an easy flow of deployment in a productive environment. Just by adding the screen to the database (SQL) it converts the Greek symbol the...
asked by 02.10.2018 / 12:45
1
answer

not in the same table

Let's say I have the CON_CONTRATOS table and I have con_customerId , con_vencimento among others. And I need to do a select that returns me ALL the contracts of a customer whose contract is only with con_vencimento not nul...
asked by 05.10.2018 / 13:07
1
answer

Error performing fetch by date greater than 1 year DATADIFF () and DATAADD () function

Hello, I need to make a select in a database where the databuffer is older than one year. However I need to use a clause and in my where and when I try to use the DATEDIFF () and DATEADD () function in this way it does not return anything. Is th...
asked by 26.09.2018 / 19:16
0
answers

Replication of tables with different databases

Hello, I have a database in sqlserver and an application with mysql database, I would like to know if there is a way to synchronize a table in both banks. Example: there is the table "mytable" in sqlserver, I want everything in it to be reflected...
asked by 04.10.2018 / 21:37
0
answers

Problems with query in the bank using PreparedStatement

I have a problem with using preparedStatement. I have a very large SQL query (very large String), so it gives syntax error. However, when I remove some parts of the code, the error is different by increasing exactly how much I removed from the s...
asked by 02.10.2018 / 21:33
1
answer

Cumulative count per month

I'm having trouble getting a cumulative count in mysql. I need to count the amount of active registration accumulated in each month. Table: id | data_cadastro | data_exclusao ---+---------------+-------------- 1 | 2018-07-01 | null 2 |...
asked by 29.09.2018 / 16:47
1
answer

Create database and MongoDB user via shell

I need to create a MongoDB database and user, but everything via shell. I found something about --eval and --shell, but I could not get it to work, I'm trying this way: mongo mongodb://11.11.123.321:27017 --eval "db.createUser({user: "...
asked by 28.09.2018 / 22:44
0
answers

"SQL syntax error" DO NOTHING after 1 year running

For 1 year my company's software worked if it got into trouble, until on a beautiful day out of nowhere this happens (it's giving us a lot of headache and cost): PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42...
asked by 29.09.2018 / 00:14
0
answers

Foreign characters being inserted into the Oracle insert

I have an oracle XE database, I want to import scripts into sql to fill tables, however, characters with accents and Ç for example get strange characters for example. In this example insert: Insert into PESSOA (ID, TIPO, CPF_CNPJ, RAZAO_SO...
asked by 18.09.2018 / 04:29
1
answer

Error inserting data into recordset with provider oraOLEDB

Good afternoon guys. I have a problem with several applications here in the company that are in VB6 . When I try to include a record in a recordset an error occurs (it is described in the code), however it only happens when I use provi...
asked by 19.09.2018 / 22:29