Questions tagged as 'sql'

Tagged questions
0
answers

how to bring a record of a table if and only if a state is fulfilled in records of another table refererda to the id of the first?

What I seek to obtain is that if the subject has correlatives, that all are in state 1, approved, and if it has any not approved or is not in the record that does not bring the subject. I have three tables:    subject (id, description)   cor...
asked by 22.05.2018 / 06:26
0
answers

SQL error Msg 156, Level 15, if 2 = 3 enter to make the select. HELP

CREATE TABLE bit13 ( ID INT IDENTITY(1, 1) PRIMARY KEY, campo_pk VARCHAR(100) ) DECLARE @campo_pk VARCHAR(100), @campo_pk2 VARCHAR(100), @campo_pk3 VARCHAR(100) SET @campo_pk = (SELECT campo...
asked by 22.05.2018 / 01:43
0
answers

TRIGGER SQL ORACLE

Someone knows how I can make a trigger that at the moment of connecting to the database, check if the user system is connected at that moment. In the affirmative case, an error should be thrown and the user should not be connected.     
asked by 20.05.2018 / 21:07
0
answers

Configure the display of rows in integration service

I have a very specific question, As you can do to configure the integration service environment and I see the numbers of rows in the flow I can not get where that is done , thanks     
asked by 20.05.2018 / 19:37
1
answer

Avg for null with left join

I have two tables (answers and answer_points) related by response_id. There are answers that do not have punctuation. I need to get all the answers with your average scores. I use this query: SELECT 'respuestas'.'id_respuesta', 'respuestas'.'t...
asked by 19.05.2018 / 21:19
2
answers

[Parse error: syntax error, unexpected '' Please fill all the cam '(T_CONSTANT_ENCAPSED_STRING) in C: \ xampp \ htdocs \ index.php on line 8]

This is the code, I've been looking for a long time and I'm not able to find the error / errors. (I'm very new) Thanks in advance! <?php session_start(); include_once "conexion.php"; {     if($_POST['usuario'] == '' or $_POST['password...
asked by 18.05.2018 / 12:29
0
answers

Is it possible to have a strong entity that encompasses several entities in database modeling?

I am in doubt about the database modeling I mention the case: I have a database with some of the tables that are PERSONA (nro_documento,apellidos,nombres,fnacimiento,id_genero,id_tdocumento) TRABAJADOR (nro_documento,codtrabajador,sueldo,id_de...
asked by 18.05.2018 / 13:23
1
answer

Query with multiple records returns only one record

It returns only one record and in my DB there are 3. I suspect that the problem may be in the query, with the theme of concatenating tables. Here my sentence: SELECT productos.nombre, productos.name, productos.precio, categorias....
asked by 25.05.2018 / 18:08
0
answers

Python Peewee AttributeError - When I consult with more than one join

I am trying to make a query with ORM Peewee with a connection to an existing database . Specifically I need to relate three tables with joins but I get the following error: (work) C: \ Users \ eguzman \ Documents \ python-work \ asterisk-...
asked by 17.05.2018 / 23:28
0
answers

sql query sent with an array from jquery

I need to make an sql query with the results of an array so that it picks up some specific bbdd values var array_ch=JSON.stringify(ar); $.ajax({ url:'php/ch.php', type:'POST', data:{ch:array_ch},//aqui esta el array que...
asked by 16.05.2018 / 23:42