Questions tagged as 'sql'

Tagged questions
1
answer

Popular DataGridView with Entity Framwork

I have in SQL Server a database called STORE; In this database I have a table named Functional, it contains 5 columns being respectively: Name, CPF, DataAdmission, DataDemission, In my C # application I have already made the connection to th...
asked by 09.06.2017 / 03:58
1
answer

SPLIT_STRING in several 'paragraphs'

I'm trying to pick up this type of table: In which I have a daily import for a dbo, I have now had difficulty doing the split_string of the comments, doing the respective cross with the ID. The idea is to have as many rows as (Additiona...
asked by 09.06.2017 / 00:17
1
answer

How to make an insert in this table

I have a vehicle registration, which has a combo box with the years for the user to choose, these years comes from the "year" table. When I complete a registration of a new car, I have to give an insert in the table "car", my problem is there, h...
asked by 09.06.2017 / 04:36
0
answers

How to do a SQL query via Socket?

How to get the client to pass a query to the server and then return what the client requested? Example: The client passes the server the string: sql = "Select nome From Aluno"; and the server would have to return the name or the names...
asked by 06.06.2017 / 20:05
1
answer

Variable float with 2-digit precision after the comma in sql oracle

How do I create a float variable with 2-digit precision after the comma in a table in SQL / Oracle. Thank you in advance.     
asked by 06.06.2017 / 15:36
1
answer

Add hours worked Mysql

I have track records of a truck in a table.    ===================================================== ==== This example up there I have 5 records that I picked up in the table by checking Speed > 0 Records 1 through 3 show that it...
asked by 06.06.2017 / 01:28
0
answers

How to Update 2 tables with Switch case and database data and others coming from an xml return?

switch / case that runs in the bank to see which id ta and get the value in the switch and pass to the other table in the update ... is there any error anyone could help? <?php require_once("core/config/config.php"); if (isset($_POST[...
asked by 24.06.2017 / 17:45
0
answers

PDO, Select a query with some fields, of a certain user and code

I need to set up a query where I will only have 5 fields ( STATUS , ID_USUARIO , PACKED , ID_TRANSACAO and ENTREGUE ). I need when I change from STATUS change in another table, and update in the current fi...
asked by 24.06.2017 / 05:48
1
answer

Exercise involving Function in PostgreSQL

The question would be: Having the following Bank: Telefone (id, numero, operadora_id) Cliente (id, cpf, nome, rg, sexo, uf) Operadora (id, nome, cnpj) Contrato(id, cliente_id, telefone_id, plano_id, data_contrato, valor_final) Plano (id, va...
asked by 11.06.2017 / 23:35
1
answer

I need to take the patient id from the table to the next page, along with the user, by clicking the button

<?php $conexao = new mysqli("localhost","root","","hospital"); if($conexao->connect_errno){ echo"Failed to connect to MySQL: (" . $conexao->connect_errno .") " . $conexao->connect_error; } $res = $conexao->query("SELECT nom...
asked by 12.06.2017 / 13:41