Questions tagged as 'sql'

Tagged questions
2
answers

Error: "You have an error in your SQL syntax"

The error that returns to me is: A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0) VALUES ('admin@hotmail...
asked by 04.06.2017 / 03:29
3
answers

Combobox with selected element based on an identifier

I have the following Form: What I want you to help me is that when you put a District Id in the text box, in the comboBox you select the district corresponding to the id entered Here I leave my code public class daoempleado{...
asked by 05.07.2017 / 23:32
1
answer

Rare behavior of Stored Procedure

I have a procedure stored in sql, when I run it in the same sql it runs all Ok: declare @x as varchar(13) exec sp_nuevo_codigo 'AGB', '' print @x go But when I run it from C #, vb, Fox Throws this error: in the Profiler: declare @p4...
asked by 22.06.2017 / 16:36
1
answer

How to add the values counted by count mysql?

I'm not realizing how to make a query and that's why I come to ask. I have the Users table in which I have the following columns: id, nombre, numero1, numero2, email And the following query: SELECT nombre, count(nombre) FROM Usuarios GROU...
asked by 16.05.2017 / 03:48
1
answer

why some files do not redirect? [closed]

Install the copy of a web system on a new server with its respective database. When doing tests I realize that some files do not direct me to what should be or redirect themselves. Do not change any code ... Why does this happen?     
asked by 26.05.2017 / 18:07
1
answer

The texts in my database are closed [closed]

I have a database in SQLServer 2005, and a couple of months ago in 2 tables we started to cut some records in a random way, I mean. If in a field before it said "hello world", nowadays it says "hello mu" or "hol". The strangest thing is that...
asked by 26.05.2017 / 22:37
2
answers

how to build two queries to the same table in one

I have this table with these two queries but I can not find a way to show the two queries in one The final result should look like this:     
asked by 27.05.2017 / 02:05
1
answer

Trigger in MySQL to send messages to the cell phone [closed]

I start with the topic of triggers and I would like to know if it is possible to create one that sends messages to the cell phone. The question has already been answered by @Michel Escalante Álvarez. Thank you very much !!!     
asked by 16.05.2017 / 16:52
2
answers

Show null or default value when bringing a query without results

I would like to be able to bring a default value after executing a query in case it does not bring any rows. I have tried a bit of everything, COALESCE, NULLIF, NOT EXISTS, EXISTS, etc. I do not know if someone has already tried it before to...
asked by 01.06.2017 / 17:49
3
answers

I can not receive the value of a SELECT query

I need to extract a single value from the database to assign it to a variable int and then use it, but I can not get it. Try the syntax of the query and return the value I need, the problem is that I can not assign it, I return the fol...
asked by 15.05.2017 / 07:23