Questions tagged as 'sql'

Tagged questions
0
answers

Problem with postgresql server version mismatch

I'm trying to restore a small, backup base on my machine in version 9.6, but it claims error when trying to create the backup via pgadmin III, I run through a bat: pg_dump.exe -h localhost -p 5432 -U Nome -n protocolo -F c -b -v -f "C:\Elote...
asked by 18.05.2018 / 21:27
0
answers

Problem upvote js

I have a problem with displaying an upvote with js. The application picks up the records in the BD and prints on screen with the upvote on the side, the upvote counter is picking up each new insert in the bd and adding it to the start variable....
asked by 10.05.2018 / 15:54
1
answer

Java createNativeQuery Insert datetime

I'm trying to do an Insert in a database whose dates are datetime2 (7). SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); Query u = em.createNativeQuery(insert); u.setParameter(1, sdf ); This is giving the following e...
asked by 21.05.2018 / 20:11
0
answers

How to Assign Vacancies from one table to Patients from another table

Galera for a project of dental consultations I need to relate two tables of patients and vacancies in order to assign the first patient who came in contact requesting a specific specialty (orthodontics, whitening, etc.) the first available wave...
asked by 21.05.2018 / 21:33
0
answers

Database Modeling Sql Server

Good morning, friends, I have a project that basically has two types of products, simple products such as market items, kg rice, 1 kg beans, etc. and compound items such as basic baskets, made up of simple items, ie inside the basket basic we...
asked by 07.05.2018 / 17:29
0
answers

User and remote connection questions in SQL Server Management Studio

I created a remote connection from my database here at work so that I can access from home just by entering the company's fixed IP. Now I need to know if it is possible, for example: I have several users created, but I want only the user "query"...
asked by 08.05.2018 / 19:34
2
answers

Replace a CASE with a SELECT and a JOIN? [closed]

SELECT DISTINCT P.CD_PACIENTE , P.NM_PACIENTE , DECODE (P.TP_SEXO, 'M', 'MASCULINO', 'F', 'FEMININO', 'I', 'INDEFINIDO') SEXO , TRUNC(P.DT_NASCIMENTO) DT_NASCIMENTO , (SELECT FN_...
asked by 04.05.2018 / 14:48
1
answer

Sum with Negative and Positive Numbers - Sql Server [closed]

I'm trying to do the sum of positive and negative values in the SqlServer database, but the same thing done by the calculator returns a different value. I'm using SUM(NR_QUANTIDADE) The NR_QUANTITY column is of type float in the databas...
asked by 04.05.2018 / 14:32
1
answer

Connect in bank sql a bank postgres

Scenario: I have the database postgres A, however I need to connect to bank A from sql server 2017. How can I do this?     
asked by 10.05.2018 / 23:38
0
answers

How to read TIF file tags saved in SQL Server type data Image

I have a database with thousands of Gigas in Mult-Page TIFF images that will be written to backup tapes. I need to read the Tag PageNumber where the number of pages containing the file is, so that the program can estimate how many tapes will...
asked by 02.05.2018 / 21:20