Questions tagged as 'sql'

Tagged questions
3
answers

get data from a table, transact sql

Dear, I need your help with this problem that I encountered when trying to obtain certain data from a table. It happens that I have a table that stores the telephone numbers of the customers who call to make a certain purchase, the purchase is d...
asked by 02.03.2017 / 02:43
0
answers

How to make a query Inner Join in Django

I have the following models: class perfil(models.Model): usuario = models.OneToOneField(User, on_delete=models.CASCADE) carrera = models.TextField() promocion = models.TextField() telefono = models.TextField(max_length=11)...
asked by 20.02.2017 / 20:13
1
answer

Add headings in flat file txt

I have 2 Querys generated one that is from clients and another from suppliers. They are both different Querys. But when you download them to a flat file, I join them in the same file, but they are separated by the clients and providers , j...
asked by 21.02.2017 / 16:58
1
answer

Environment for manipulating MySQL data [closed]

Dear. I need to provide an end user, who does not know SQL syntax, a simple way to update and filter data from a MySQL database. Do you know any tool that facilitates this? Or something that can be integrated with the base to make simple queries...
asked by 20.02.2017 / 22:54
1
answer

PDO in two different INSERT?

Is it possible to make two prepared statements in two INSERT of different tables that I have in a record, that is, one prepared for each one? For example, I have this: INSERT INTO datos (nombre, email) VALUES('$nombre', '$email'); INSERT IN...
asked by 13.02.2017 / 16:43
2
answers

Considerations on using the JOIN in SQL Server 2008

I have a problem with its use. I have two tables in different databases, both tables are identical (same number and name of columns) and the smallest is included (all their records) in the original table. Both tables give me the same number o...
asked by 10.02.2017 / 20:59
1
answer

Help with sql view

I'm stuck in an exercise for class, the teacher has also tried to help me and has not finished leaving ... the statement is as follows: Create a view, called top_patients, that collects the patient from each city that has spent more on visits...
asked by 02.02.2017 / 16:18
1
answer

pass data from the datagrid of one form to the textbox of another form wpf

I have the following code to load my data into a datagrid of a form Private Sub cargarGrid() Dim conexion As New ConexionBD Dim data As DataTable dataGridVehiculos.ItemsSource = Nothing Try data = conexion.mostrarDatose...
asked by 08.02.2017 / 15:00
1
answer

Wrong number of parameters

I am using prepares statements to improve a query I am making, but it generates the error:    Wrong number of parameters The code is as follows: $start = new DateTime('first monday of January 2016'); $end = new DateTime('last day of D...
asked by 08.02.2017 / 02:17
1
answer

Full Outer Join in Laravel

my query is like doing a FULL OUTER JOIN in Laravel, I have version 5.1 Example: Thank you very much.     
asked by 31.01.2017 / 03:38