Questions tagged as 'sql'

Tagged questions
0
answers

problem with foreach in mvc 4 asp .net c #

my problem is based on a table RESTRICTIONS, which is based on a turn-taking system, these restrictions can be created by the admin from its backoffice, so to go through this table I use a foreach, and for example I rely on The common restrictio...
asked by 23.10.2018 / 04:11
1
answer

sql query showing a repeated record

I have the following query that I do in SQL server select celular, razon_social FROM clientes where celular <> '' AND LEN(celular) = '10' AND ind_estado = '1' AND ISNUMERIC(celular) > 0 ORDER BY celular it brings me records norm...
asked by 23.10.2018 / 23:45
0
answers

Free database connection never stops loading

I am trying to practice sql with a free host, but although I have correctly put all the connection data, the delay time to connect seems to be too much and my localhost sends me the following message: "Warning: mysqli_connect (): (HY000 / 2002):...
asked by 23.10.2018 / 21:45
0
answers

SQL Server and query with different problems (sqlserver)

Hi everyone, I've been working on this server for a short time, and I just have a problem, I need to consult a table to create a report with reporting services (SSRS). My problem: I need to show the benefits of the company of the period th...
asked by 22.10.2018 / 15:53
1
answer

MySQL events between 12 hours

I'm creating an event that was already created in Sybase, this is done so that it runs every hour but it does between 7 in the morning and 7 in the afternoon. Does anyone know if this option is available with MySQL? I've been watching but I do n...
asked by 22.10.2018 / 15:23
1
answer

Error executing stored procedure code to register data in mysql [closed]

CREATE PROCEDURE sp_registraVenta( INOUT cod int, cli varchar(150) ) BEGIN SET cod =(SELECT IFNULL(MAX(Cod_venta),0)+1 into cod FROM venta); INSERT TO venta VALUES (cod, cli, CURDATE()); END; Good day I had problems with this code beca...
asked by 21.10.2018 / 18:56
0
answers

How to insert data into tables related to primary key autoincremental?

Well I got a little problem that I have my class diagram and I want to insert data to 5 tables that are related to each other Here I show you my tables that I have and also I will put an image of all my diagram that made this little system that...
asked by 21.10.2018 / 07:02
1
answer

Help with Fetch_Array

I am practicing returning data from a database to my web page, with the FETCH ARRAY method. I would like to be able to return, for example, all the values of the NameAlumni field, but until now I have only managed to return the first value, and...
asked by 24.10.2018 / 00:46
0
answers

how to do an update sql query correctly

I am setting up a stored procedure to update some data in a table but when I update it executes correctly but does not write anything about the database USE [qappdotnet] GO /****** Object: StoredProcedure [dbo].[webhook] Script Date: 10/23...
asked by 24.10.2018 / 01:26
0
answers

Load values in JAVA nested combobox

Good day have all hope I can help with this problem. I have 3 tables which are Price, Products and Customers List, Price List is related to products and customers, to add a price list I have to assign a customer and a product with their respecti...
asked by 19.10.2018 / 21:10