Questions tagged as 'sql'

Tagged questions
0
answers

Query to order data insertion [closed]

Greetings. When clicking on the + button in the second row of table 1, I get the result of table 2 (new row). I need that when I update the page, the data stays in the position where it was created or deleted. What kind of query would you need?...
asked by 29.11.2017 / 15:33
3
answers

Error Order By Clause is invalid SQL Server

I would like you to help me with the error in the Order By, because it marks me the clause error CREATE PROCEDURE SP_ExportExcelHistoryPRUEBA -- ALL DATA DEFAULT(TODOS LOS DATOS) AS BEGIN SET NOCOUNT ON DECLARE @TODAS VARCHAR(100) --...
asked by 08.02.2018 / 02:30
1
answer

Problem when evaluating if a point belongs to a polygon using the GEOMETRY data type - SQL SERVER 2014

Good morning, I am setting up a procedure in T-SQL to detect if a point belongs to a polygon in the following way: By putting an exact point that is in the polygon, the STContains method should return a 1 (Belongs) and is returning a...
asked by 07.12.2017 / 13:31
1
answer

Why does not the routine table from the employees table be transferred to the study table as an invalid?

Why when I try to pass the foreign key which is a rut that is inside the table used for studies, it tells me that it is invalid? I attach images of the error and the tables. SQL> CREATE TABLE EMPLEADOS( 2 RUT CHAR(10), 3 NOMBRE VARCHA...
asked by 18.11.2017 / 20:07
1
answer

Delete line null file created CMD

I have a batch which takes the name of the file and path of a parameter in a table and then executes a select and saves it in a txt. The problem that is occurring is that in the last line I create a record with NULL (I am going to attach an imag...
asked by 24.11.2017 / 18:37
1
answer

Filter expressions in SQL query

I am trying to perform a query in SQL Developer (Oracle) on several tables. In which I need to compare the result of expression if it is Greater or Equal (x> = 0) or if it is Minor: X >= 0 => Resultado: 'S' ; X < 0 => Resultad...
asked by 22.03.2018 / 18:03
2
answers

Duplicate value ERROR, but I need to identify the field

My question is very simple but I guess we are all here to support each other and keep learning. My problem is in this line of code: INSERT INTO DEPENDIENTES VALUES (78900456,'Oscar','M',15-01-89,'Hijo'); the error bounces me...
asked by 22.10.2017 / 21:55
0
answers

Notice: Trying to get property of non-object in C: \ xampp \ htdocs \ login \ log.php on line 18

<?php $connect= new mysqli('localhost', 'root','' ,'prueba2'); if($connect->connect_error){ die('connection failed'); }else { echo 'connection worked'; } $username= $_POST['username']; $password= $_POST['password'];...
asked by 04.12.2017 / 03:01
3
answers

Find the second space in a string in SQL [closed]

I am working with names of the type "Surname 1 ° Name 2 ° Name" and I need to know in which position the second space is located, so that I can then remain alone with the last name and the first name.     
asked by 18.10.2017 / 21:33
1
answer

Query about time range in SQL Server? [closed]

Good day, I have to make a query about the generation of alarms, I want to know how many seconds it remains active (Column: EventTime) every period of power on and off (Column: Message), of the time that passes in that time I want to gener...
asked by 10.10.2017 / 22:37