Questions tagged as 'sql'

Tagged questions
1
answer

Concatenate results

How to concatenate all results of a query in SQL Server in order to return all information in a variable? For example, considering a cliente table with the following composition: ╔═══╦════════════╗ ║ ║ Nome ║ ╠═══╬════...
asked by 11.05.2017 / 19:49
1
answer

SQL command to add the vacancies occupied on a specific day of a parking

Personally, I'm having a little problem finishing a college job and would be of great help if you helped me with a small VIEW. Here are the fields of the parking table: CREATE TABLE Seg.Estacionamento ( valor_hora decimal(4,2), numero_vagas...
asked by 23.11.2017 / 00:50
1
answer

Doubt - Query SQL Server 2012

Good morning! I have a query below that I need to bring inside the case only when the TarVencimento is smaller than today's date (so far I have been able to do it), but only when today's date is until the 5th day after the date of maturity. E...
asked by 22.11.2017 / 12:20
1
answer

Android Application and MySQL Database

I have an application developed in Android and I need to connect to a MySQL database that is local to a Desktop. I can easily get the IP address of the machine where the bank is. How can I make the connection between the application and the loca...
asked by 06.12.2017 / 19:44
0
answers

SQL developer user and password

During the installation of SQL developer 17.3.1 on ubuntu 16.04, it did not prompt user and password. In this case I can not log in, is there any default user or some way to set up a user?     
asked by 20.11.2017 / 19:28
1
answer

I can not find the login error

I'm logging in, but even when I put the data of a registered user, invalid data appears. login.php <?php session_start(); require_once "Classes/UsuariosDAO.php"; require_once "Classes/UsuariosVO.php"; $objUsuario= new UsuariosVO(); $o...
asked by 29.11.2017 / 12:26
1
answer

MySql - How to make a Stored procedure be activated once a day?

I need a Stored Procedure to be called every day at 23:59:00 but I have already tried it in some ways and when it arrives at that time it does not execute! CREATE EVENT 'ATUALIZARDADOS' ON SCHEDULE EVERY 1 DAY STARTS '2017-11-16 23:59:...
asked by 17.11.2017 / 13:50
1
answer

Procedure does not return the entire column

I created a procedure with ibexpert, does commit correctly, but at the time of running procedure , I get the error:    multiple rows in singleton select. My intention is to list all the values in the city column of the target table. Whe...
asked by 01.12.2017 / 06:56
1
answer

Update through another table - Mysql

I have the following problem: I have a rev_tasks table that contains id as a key, and a second rev_reviews table and has a foreign key task_id , pointing to the task, and I have a ( revised ) field review has been revised or not. In rev_...
asked by 16.11.2017 / 13:15
2
answers

Last records based on a filter

Next, I need to bring in a query the last records that have not changed in the last 3 days from a specific ID , eg (id_chamado_status = '1') .     
asked by 14.11.2017 / 17:40