Questions tagged as 'sql'

Tagged questions
2
answers

How to calculate distance between two points in sql server

I would like to obtain the distance between two points in sql server, the problem I had previously, is that I had the data latitude and longitude in a single column, which I already managed to solve that problem through a split, now I would like...
asked by 14.04.2018 / 21:52
3
answers

Help with SQL query (several records in the same field)

I hope to explain myself well and that you can help me, thanks in advance, the situation is as follows: I am developing a system that diagnoses computer failures, which will work in the following way, the user will select several symptoms and...
asked by 06.11.2018 / 11:42
1
answer

Divide result of a query with many fields in 2 lines

I have a table with these fields: Usuario1 Nif1 Nombre1 Telefono1 Usuario2 Nif2 Nombre2 Telefono2 1 213 Pepe 123456 2 546 Juan 89173 3 456 Miguel 43434...
asked by 21.09.2018 / 16:54
1
answer

I can not connect to my server in SQL Server 2014 network

Hello everyone I have the following problem: I am connecting to my server sql server (use sql server 2014) and is able to connect using the ip address of the server (eg 192.168.1.x \ SQLEXPRESS). But when I try to connect to using the server nam...
asked by 01.09.2018 / 07:40
1
answer

Doubts in PHP and SQL Ready Queries, SELECT Statement and Show Data

I try to update some systems that I have created, in which I try to add consultas preparadas to improve mainly the security. I'm trying to do a SELECT and it's not clear to me how I could go through it. $sql = "SELECT * FROM c...
asked by 08.09.2018 / 15:46
1
answer

Inconsistency in reading a flat file ("?") C #

I am reading a flat UTF-8 source code file and I read it with UTF-8, so far everything works fine, but I have a record that for reasons I can not find yet, it brings me a question mark when I register it in the BD, but I do all the follow-up and...
asked by 03.09.2018 / 18:08
1
answer

How to return a zero when it is null

I have an SQL with two files: First file PRODUCTS: (PRD) PRODUCT FIELD Second file STOCK: (PRD2) FIELD PRODUCT, (STOCK) FIELD STOCK If I do one: Select PRD, STOCK from PRODUCTOS inner join STOCK ON PRD=PRD2 It clearly returns th...
asked by 20.08.2018 / 22:35
1
answer

Enable remote connection to oracle database 12c

I have a database on a server and locally the connection is correct with sqldeveloper but if I try to access from another ip it stays loading and the connection drops by timeout, I understand that I must enable the remote connection but I can no...
asked by 28.08.2018 / 00:01
1
answer

Is it possible to obtain two independent results (sum) from a single query in LINQ?

I am modifying a program and I want to obtain two sums independently of the id and save them in independent variables one of another. It would also be useful to obtain a table resulting from a line with only the two columns added. With this e...
asked by 22.08.2018 / 12:18
2
answers

PHP print Value of Select according to variable

I already show the values of my database in my table correctly but I would like that if I select the option with the id = 1 show the information with an echo related to that information, something like this is my code: <?PHP //esto es...
asked by 10.09.2018 / 19:41