Questions tagged as 'sql'

Tagged questions
2
answers

In MySQL how should the data types be declared in case of using the following elements in JAVA

1) If you are going to create a password with JPasswordField, what type of data should be declared in the SQL database ... would it be varchar or another? I understand that the passwords are encrypted and ask for another type of data. 2) In t...
asked by 18.05.2017 / 03:41
2
answers

Multiple SQL SELECT

I have 5 tables with many records. Each table has "Date" columns, in which there may be only one date per user (the last date on which a user modified their profile is stored, for example) or many dates per user (the dates on which the user has...
asked by 15.05.2017 / 09:36
2
answers

How to Validate Logeo sql server in store procedure with input variables

> Buenas noches quisiera que me puedan ayudar estoy realizando una > validación : Bueno la verdad estoy realizando un Logeo que todos los usuarios van tener 3 intentos al ingresar con lenguaje c# con **sql > server y procedimie...
asked by 13.05.2017 / 07:44
1
answer

Print a query sql the count (*) in php

I have this query prepared in a php file. $consulta = $conn->prepare("SELECT examen.idexamen,examen.detalles, count(*) from examen,preguntas having count(*) IN (SELECT count(*) FROM preguntas group by pregunt...
asked by 15.05.2017 / 10:13
2
answers

How to search by date in a timestamp

I have dates stored in timestamp of the form: 1999-01-08 04:05:06 1999-01-24 13:22:29 What I want is to make a query between ranges of dates that is: Inicio: 1999-01-09 Fin: 1999-01-12 It returns the records with a date between 1999-0...
asked by 09.04.2018 / 22:33
1
answer

Using INNER JOINs with USING, ON or WHERE (where tabla.column)

I've learned the USING doing things like this: SELECT nufactura,des,cantidadc,precio,precio*cantidadc AS "SUBTOTAL" FROM 'facturas' INNER JOIN 'fac_pro' USING(nufactura)INNER JOIN 'productos' USING(codigop) WHERE nufactura = "700" ORDER BY...
asked by 24.05.2017 / 03:15
2
answers

SELECT pii2 FROM 'surveys_egresados' WHERE pii2 = 'Very good' BETWEEN date = '2017-01-01' AND '2017-01-01'; [closed]

I have a syntax error in the following statement SELECT pii2 FROM 'encuestas_egresados' WHERE pii2='Muy buena' BETWEEN fecha ='2017-01-01' AND '2017-01-01' ;     
asked by 21.12.2017 / 00:10
3
answers

How to get the minutes of a date field

I am trying to update the records in an Oracle SQL database and I can not find the correct sentence. The EXPENSES table is composed of the following fields: DATE TYPE: DATE REGISTER EXAMPLE: 01/01/2018 12:00 SPENDING...
asked by 05.09.2018 / 17:58
1
answer

Copy structure of table type [closed]

BD: Sql server 2014 I have a table "User-defined Table Type" what I need is to copy its structure (columns) to a temporary table     
asked by 26.05.2017 / 01:05
1
answer

failed to perform Convert.ToInt32

public int cantPembarcar(String pCodigoArticulo) { string strCon = ConfigurationManager.ConnectionStrings["Sk_DBRadioFrecuencias"].ConnectionString; SqlConnection conn = new SqlConnection(strCon); SqlCommand comm = new SqlCom...
asked by 02.04.2017 / 00:09