Questions tagged as 'sql'

Tagged questions
1
answer

update with double condition in c #

I need to update a field of a record in my sql database using two conditions I'm trying to do it in the following way sql = "UPDATE detalle_pedido SET cant_ingresar = '" + Convert.ToDecimal(TextBoxCantidadCargar.Text.Trim()) + "' where codi...
asked by 30.10.2018 / 20:42
2
answers

Help with Query without showing all the results

Good day, I have a little doubt, I hope you can support me. I'm doing a query in a DB, with the following code: select status as EstatusReporte, count (status) as TotalReportes from Reportes where CveAuxiliar = Numero group by Stat...
asked by 19.10.2018 / 17:42
2
answers

How would you do toMost quantity of products sold in the summer months (January-March) of all years (from 2000 to 2006)

Show quantity of products sold in the summer months (January-March) of all years (from 2000 to 2006).     
asked by 16.11.2018 / 03:33
2
answers

SQL Clear table with foreign key

Good day, I'm starting with SQL and during the development of the project my question arose. The issue is that I have a Detail table And a product table The problem arises when I want to delete a product, due to the reference t...
asked by 18.11.2018 / 01:15
1
answer

To work with asynchronous programming, do I need an asynchronous connection?

Good morning friends I am seeing some tutorials on the management of asynchronous programming with .net, in windows form .. many show concepts and basic practices on how to implement it. But my doubts is. when we want to work with persistence...
asked by 17.10.2018 / 17:16
1
answer

MySQL Inner Join with null Id columns

I have a table where there are several related ids and using inner join I get the data the problem is that some records do not keep an id and I put value Null and when ago the select with inner join does not show me the data with null value T...
asked by 09.10.2018 / 19:49
2
answers

Several database operations that behave as one

I am doing a system in which, on occasion, I must perform 3 or more movements in the database: read a field, insert in another table, and update some tables; the situation here is that, sometimes, the insertion or update is not done due to some...
asked by 03.03.2017 / 20:14
2
answers

problem with checkbox and php

I have a check-box that the user will indicate respective months of a form, I can send it if you select January and February but if you select other months or January, March, December to say something, do not save it in the database. <?php...
asked by 14.10.2018 / 08:36
1
answer

Help with MVC (pass html data to a controller) [closed]

Good evening everyone I need help with something I have in a view something like this <h5>Cuanto es 16/8</h5> <div class="radio-btns"> <div class="swit"> <div...
asked by 17.09.2018 / 02:13
2
answers

Insert SELECT in a table

I'm trying to insert all the fields with a specific id into a table, I get this data from a select, I want to put them in a table to make queries with the data in this table as a reference. This is what I have declare @json varchar(max)...
asked by 11.09.2018 / 20:36