Questions tagged as 'sql'

Tagged questions
2
answers

SQL SERVER Transaction File LDF

I have started using sql-server , in the database I have configured the transaction file to grow by 10% as needed, but up to a maximum size of 2Gb. When the file of transactions (ldf) reaches the established limit of 2Gb, does it stagna...
asked by 28.03.2016 / 10:27
4
answers

Problem with foreign key when deleting artist in java

Good, I'm doing a program to add / remove / modify artists from a database and when I try to delete the artist I skip this:    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:   Can not delete or update a parent row...
asked by 07.05.2016 / 18:51
1
answer

create temporary tables mariadb 10.1.21 from php 5 and be able to make a selection of them?

I am trying to create a temporary table from php but when doing the select it tells me that: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given in The code is as follows: mysqli_query($db,"DROP TABLE IF EXISTS T");...
asked by 04.01.2019 / 20:42
1
answer

Unable to convert a DBNull object to other types

I am creating an application in which you can make reservations, in the mapper of the properties I have passed a method called "LoadProperties" in which I pass the data such as type, etc, the problem is when you I want to pass the user who has r...
asked by 15.07.2016 / 19:23
1
answer

display data from a selectbox on sql server

As my question says, I need to know how to show data when selecting an option of a selectbox. My code is as follows and I use SQL SERVER (it's worth saying, since most tutorials are for mysql) <?php define('DB_SERVER','x.x.x.x'); define(...
asked by 28.12.2018 / 01:31
1
answer

AUTI INCREMENT in an oracle table

Good I want to create a table in an oracle scheme called CA: CREATE TABLE PDT_CONCEPTOS( ID INT(8) NOT NULL, NOMBRE VARCHAR(250) NOT NULL, CODIGO_PDT VARCHAR(8) NOT NULL, CODIGO_DB VARCHAR(100) NOT NULL, DESCRIPCION VARCHAR(250)NOT NULL,...
asked by 28.12.2018 / 22:45
1
answer

Create a new column in SQL table

I have a problem and I hope someone can help me .. I have an SQL table with these columns: What I need is to create a "Total" column that is unitPrice * amount, but I have tried several alter tables and they have not worked for me....
asked by 04.12.2018 / 23:39
1
answer

Save orders in database

I have a cart and I am working on the button to confirm the purchase. The products arrive to the cart by means of a while, and I keep the data I need from each article in variables. The problem is that when doing the submit only print the values...
asked by 02.12.2018 / 16:10
2
answers

GROUP BY with null values

SELECT s.producto,s.entrada AS entrada,r.salida AS salida,s.mes,s.anio AS anio,s.entrada-r.salida AS total FROM (SELECT MONTH ( fecha ) AS mes,YEAR(fecha) AS anio, producto,COALESCE(SUM(cantidad),0) AS entrada FROM eProductoTerminado WHERE...
asked by 24.08.2016 / 20:38
1
answer

SQL query that as a result the questions have been answered 4 times in a row

I wanted to get a query to return the "question number" according to the following parameters: That it meets: -What idUser = 1 -What mode? Questions? Operator of Services - That the last 4 times that has been answered has had as a value the a...
asked by 09.12.2018 / 19:30