Questions tagged as 'sql'

Tagged questions
1
answer

summation query

I'm having a kind of problem with this Query, but what I want to happen is for all values like: Goals Scored , Assists Made , Key passes etc, only once. SELECT s.[Statistics ID], s.[Player ID], s.[Game ID], s.[Season ID],...
asked by 19.01.2015 / 18:55
2
answers

Search for elements with a certain distance of time (only reporting the time)

Detail sqlserver (2008) Good night, I have the following problem. I tried searching all day and found nothing. -I need to find elements in a same table that have the same date (day, time ...) and a time distance of at most 40 seconds from one to...
asked by 09.11.2018 / 22:08
1
answer

Sql server convert String time to Decimal

I have a question about how to convert a string column that returns the time as '08: 00: 00 'to decimal, exactly as Excel does, when changing the format to numero for example: '08: 00: 00 '=' 0,33333333 ' Thank you in advance     
asked by 18.10.2018 / 22:52
1
answer

C # hash encryption

I was able to create a registry with encrypted password, but in the method of access (log in) I am in doubt on how to get the password entered and compare it with the password registered with encryption. Here is my code: class FuncionarioDAO...
asked by 16.10.2018 / 04:33
1
answer

Union Junction Operator [closed]

I need to show the departments that had stock movements in Feb / 2018 and those that had in March / 2018. I need to use a joining operator to show the results of the two queries each returning the departments for a month. In every query I should...
asked by 10.10.2018 / 02:57
2
answers

SQL Join JOIN

I need to work out a query that brings the employee's registration, employee's name, and employee's city name using JOIN . But as I have no experience yet with this function, I'm stuck !! For this I have the funcionario table and th...
asked by 06.10.2018 / 02:45
1
answer

Specific lines of a table

Hello! I have the table OPERACAO where I have 3 columns: Codoper, description, nautureza. I have to design the description and nature of all input operations. Then sort by the operation code. Operation code 1, 3 and 6 are my input operations. Co...
asked by 07.10.2018 / 16:32
1
answer

ALTER TO - SQL SERVER

In my bank I have 2 stored procedures, dbo.A and dbo.B. in the procedure dbo.A there are the parameters @name, @rua in the procedure dbo.B there are the parameters @cep, @telefone But I also need to have the dbo.A rbo parameter in dbo.B. I ne...
asked by 28.04.2016 / 13:04
1
answer

Error adding FOREIGN KEY to table already created [duplicate]

I have a table that needs to be changed to have a foreign key    ALTER TABLE bancocliente.producto ADD CONSTRAINT fk_fabPro FOREIGN KEY   (cod_fab) REFERENCES bancocliente.fabrica (code); I get the error message: Erro SQL (1452): Cann...
asked by 12.07.2018 / 20:50
2
answers

what should I do to authenticate user correctly [duplicate]

I need help to authenticate users on my site but I do not know what the sql variable that estanciei returns when it finds the right user what I put in if? <?php include 'conexao.php'; $conexao = conexao::getInstance(); $login = $_POST[...
asked by 07.06.2018 / 19:44