Questions tagged as 'sql'

Tagged questions
2
answers

Error editing a visual studio project in another pc

I'm developing a project in Visual Studio and this project I'm continuing on a new PC, my problem is that when I run the project to know how it goes I get the following error.     
asked by 23.10.2018 / 21:44
1
answer

Show products that have not been sold in 2018

To show those that do not exist use this: R = product.name From: product, order Where: product.cod_prod - order.cod_prod     
asked by 28.10.2018 / 20:55
1
answer

help mysql java netbeans

package Principal; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; public class Galerias { Connection con = null; public void Insertar(String nombre, String ubicacio...
asked by 26.10.2018 / 16:19
1
answer

Migrate an .sql file to MongoDB?

I want to import a database from a file .sql to MongoDB, the problem is that it weighs 1.7GB. I was researching and found that I can import a database to mongodb as file .json , but the pages to convert to .json do not suppor...
asked by 24.05.2018 / 21:58
1
answer

SQL Managment starts and before login closes

The query is the following: Why does SQL start and before showing me the login closes alone? Context. Install Sql Server - Sql Managmente Studio 2018. It worked perfect, I was working until a few days ago. I connect to the database of the w...
asked by 01.11.2018 / 14:34
1
answer

How to get the average life of the records?

I want to take the average life of all the records that exist for example if an employer withdraws Head protection - APRO - Helmet - Steel pro - Complete wing - N / A - 5 - 30-10-2018 , and then the next day remove the same product the av...
asked by 31.10.2018 / 15:20
1
answer

Do not throw me the expected result when I use the inner join

the first code brings me the result well select t.TransaccionId, t.NetAmount, t.UserId, t.Id_movimiento, t.CreatedDate from TablaPrincipal t where id_movimiento is null the second code select t.TransaccionId, t.NetAmount, t.UserId, t.Id...
asked by 06.11.2018 / 20:49
1
answer

Perform query MAX () within a SUM () in SQL

I have a query which shows me the sum of money by means of a SUM() and shows the VALOR of the money grouped by PLACA in this way: SELECT PLACA, SUM(VALOR) AS SUMA FROM 'huawei_combustible' WHERE YEAR(FECHA_TANQUEO) = 201...
asked by 25.01.2018 / 22:22
1
answer

Delete characters from a string

I have a base in Access, with around 1000 records, which I convert to an SQL file. The images are saved in Hexadecimal as follows. 0x6C7400006C340000FFD8FFE000104A46494600010100000100010000FFDB00430006040506050406060506070706080A100A0A09090A14...
asked by 07.12.2018 / 17:33
1
answer

SQL SERVER WITH JSON QUERY

I have consulted with MYSQL use Jquery and Json and everything works fine. But when wanting to perform it against an SQL SERVER, I have obtained only varied error messages. What I can mention is that the MYSQL uses Utf8 while the SQL SERVER uses...
asked by 18.10.2018 / 15:31