Questions tagged as 'sql'

Tagged questions
3
answers

Problem with PHP code

I have a code that should show me certain data according to the date that the user sends by form, that is, I need to be shown a certain number of orders in a certain range of dates but it turns out that the table that I am shown this empty, atta...
asked by 29.11.2016 / 22:14
1
answer

C #. Use sql data to do access searches

Bunas. I would like to know how I can extract data from sql and use each extracted data to do a search in a database in access. This is my code. public DataTable heater() { DataTable dt = new DataTable(); DataTable dt1 = ne...
asked by 28.11.2016 / 15:22
1
answer

Exclude records that are in another table in a [closed] query

select idConceptoGastos,rtrim(NombreConcepto) from Concepto_Gastos where not idConceptoGastos in (select IdConcepto from Reporte_Formulacion) and IdPartidaGastos = '1' and Vigente = '1' and not NombreConcepto = 'ALCOHOL DE 96°'and NombreConcept...
asked by 09.04.2018 / 16:38
1
answer

Select images from the sqlserver php database

I have a query that selects information from the database but I can not print the images on the screen, the address of the images folder are in \192.168.10.129\sapshared\FOTOS\KennedyDB but the application is running from 192.168.10.134...
asked by 08.05.2018 / 14:33
2
answers

SQL QUERY - POSTGRES REGISTER REPEATED BY A SINGLE COLUMN [closed]

I have a table that has student scores: Code | test | score 123456 | p00001 | 3.2 | 123456 | p00002 | 1.0 | 123456 | p00003 | 5.0 | And I want to check out 123456 | p00001 | 3.2 | p00002 | 1.0 | p00003 | 5.0 |     
asked by 12.05.2017 / 16:08
3
answers

how to do the following query in mysql, help

Good day, I have a problem to make a query on mysql because I am totally inexperienced. I would like to know if someone can help me get what I need. In the image is the whole explanation:     
asked by 02.04.2018 / 21:24
2
answers

subtracts with selected values from different tables

I have a problem which I hope can help me, I want to add values of a tabla1 and can subtract them from other values selected from another tabla2 under condition of tabla 2 like=´A%´ adding these values and subtracting them f...
asked by 04.12.2018 / 15:13
2
answers

When can I use Linq and when to use Sql? [closed]

I have a series of doubts about when to use each of these, it would help me a lot to know their experiences     
asked by 13.11.2018 / 17:26
1
answer

Numbers ending in 99 SQL

Hello good morning community! I wanted to ask you how I can get from a table (for example a price column) all the numbers that end in "99" any ideas? Thanks     
asked by 08.11.2018 / 12:40
1
answer

error with mysqli when connecting with a bd

Good trying to have some records added to the bd but I can not get them to be saved I do not know what I should get these errors and warnings    mysqli_query () expects at most 3 parameters, 4 given in C: \ xampp \ htdocs \ boostrap \ css \ w...
asked by 25.04.2018 / 19:28