Questions tagged as 'sql'

Tagged questions
1
answer

Sql Procedure [closed]

Good afternoon, can anyone help me to create a database procedure in SQL? To make a room reservation, I have to select a room and declare the DataEntry and the DataSaid. What I want is if you make a reservation in room 1 between June 13th, 20...
asked by 13.06.2018 / 14:08
0
answers

Update within a mysql function

I have to do a process to perform an update on a given field in a table. I created a function in mysql. But within this function would need to perform an update, plus the function does not accept uptade would have any way to perform this proc...
asked by 14.06.2018 / 03:38
1
answer

Select with specific column - Oracle

I've been migrating to Oracle and found a question. In SQL Server I could do this: select coluna, * from tabela How do I get a similar result using Oracle 12c?     
asked by 11.06.2018 / 15:45
2
answers

Compare a subquery with another subquery

I have two tables, table A and table B, each with a column called text . Both tables have equal records up to a point, up to the character ' = '. What I want to do is SELECT all of the records in table A where the records up to the '=' characte...
asked by 19.11.2017 / 18:13
0
answers

Update table with XML field and on different banks

I have two SQL SERVER 2012 banks installed on server A and server B, I need to insert and then do a Update on the server table B via linkedServer by server A, but in these tables have XML fields, I am not necessarily updating this fie...
asked by 07.12.2017 / 16:23
1
answer

Query with MAX (DATE)

I'm trying to generate the query below as follows. Cliente Tarefa Data da Ultima Providencia Teste 16555 04-07-2017 However, it is generating in a duplicate way, that is, I want to get the last date of the last provisio...
asked by 18.09.2017 / 21:22
2
answers

Error when calling activity [closed]

main Activity import android.content.Intent; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; import android.view.View; import android.widget.Button; import android.widget.Toast; public class principal extends AppCom...
asked by 10.12.2017 / 16:00
1
answer

Check Connection with the bank and validate for the user

I would like to know the following: I am trying to make an application that makes several connections to the database. I wanted to always check the connections and if the connection is not available alert the user and close the running method .....
asked by 30.08.2017 / 14:31
0
answers

How to read an excel and insert data into a table?

I wanted to send data from a file Excel to a table in Sql . I've tried using bulkcopy.ColumnMappings.Add but you're giving me an error.    System.InvalidOperationException The given ColumnName does not match   up with a...
asked by 17.10.2017 / 13:37
0
answers

How to make selections through the Workbench Diagrams?

I'm migrating to Mysql WorkBench and I need to perform a relationship between SELECT... INNER JOIN... LEFT JOIN... tables, but I wanted to perform through the Diagrams schema. How can I proceed in this case?     
asked by 06.09.2017 / 21:19