Questions tagged as 'sql'

Tagged questions
0
answers

Take days apart

In the next query the column ' ROUPMJ ' I use it as a date to know when a product is available, but when I came in Juliana I converted it to smalldatetime . I need to take the difference of days to the current day in another column t...
asked by 30.10.2018 / 20:13
1
answer

How to insert a value into a database in sql with python language?

from query import PzasOP14 ns = event.source.parent.getComponent('NoDeSerie').text pok= event.source.parent.getComponent('PzaOk').text pnk= event.source.parent.getComponent('PzaOk').text tc = event.source.parent.getComponent('TiempoCiclo').text...
asked by 31.10.2018 / 18:33
0
answers

Can UNION and JOIN be used in a single query? [closed]

You can use UNION and JOIN I have a query where you use two select of which those two are using UNION and then I have another select that I want to join with a join     
asked by 18.10.2018 / 00:19
0
answers

What are the disadvantages of using a varchar (max) MSSQL field? [closed]

Currently, I work in the support of a web application where users place orders, the system works great, but there is a section in which we have had difficulties, the blog, when a user registers an order is used var jsonSerialiser = new JavaSc...
asked by 19.10.2018 / 18:37
1
answer

How to make a mysql query for php graph?

I need to make a query in MYSQL, I have the following data COLUM1 FECHA PAIS 0 2018-11-13 0 2018-11-13 Reino Unido 0 2018-11-13 1 2018-11-13 Colombia 0 2018-11-13 1 2018-11-13 Peru 0 2018-11-13 0 2018-11-13 Espan...
asked by 14.11.2018 / 13:25
1
answer

Bean does not show parameters sent from DTO

I am programming a mini form, the question is that I have 2 user and institute beans, the user logs in and enters an index where he has to fill out a form, in index I want to show both the user's name and the institute that it logs both in an o...
asked by 12.09.2018 / 21:35
3
answers

consult 2 tables to see which records are not in the first table

I have 2 tables of people from 1 system which has 2 versions, each version with a different database, what I want to know is that people from the tabla t_evaluacion_vulnerabilidad are not in the table t_evaluacion_dean , here I shar...
asked by 24.04.2018 / 15:02
1
answer

Compare 2 fingerprints using SQL and C #

Good day I have an application that I set up on the Internet, and adapt it to my needs, I have only managed to get the data captured, I used Digital Person SDK 1.6.1, I have a fingerprint reader: digital person 4500u. In my database I store t...
asked by 19.09.2018 / 20:57
0
answers

Send html form to SQL [closed]

Can someone explain to me why an HTML form does not reach the database? I mean, I fill in the fields and when he sent me he appears    "Data saved correctly" And I will update but nothing comes. I've tried with different data and it's...
asked by 04.10.2018 / 23:23
0
answers

Convert SQL to LINQ or LAMBDA [closed]

I would not know how to convert this select into linq or lambda. Mainly the group by and subqueries. select CONVERT(date, tt.FechaHora) ,(select MAX(p.FechaHora) from Transaccion p where CONVERT(date, tT.FechaHora)= CONVERT(date, p.FechaHor...
asked by 04.09.2018 / 15:04