Questions tagged as 'sql'

Tagged questions
1
answer

select count (*) from java executeQuery

How can I store the number that returns the select count (*) in a variable? public int contar_num_personajes() throws SQLException{ Connection dbConnection = null ; Statement stm = null; int n= 0; String co...
asked by 16.07.2017 / 23:22
2
answers

Convert time in SQL Server with the format: 07/19/2017 11:00:00 a. m

I have the following script to insert in the base: INSERT INTO k_horario(OIDHorario, OIDEmpleado, OIDSalon, OIDTaller, Hora, Dia, Semana, Duracion, FechaCreacion) VALUES ('3de7d494-5de9-4ab5-8d30-816103f1a9a0', '396983d6-63bd-4a0d-82fa-fb2fdac...
asked by 25.07.2017 / 02:15
1
answer

I can not access tables "in use" on phpmyadmin

Today, when I turned on the PC and started the Xampp, I saw that there are certain tables that I use and I can not access them or repair them if I select them. And it gives an error to access them. How can I access them or repair...
asked by 23.08.2017 / 14:26
1
answer

error when connecting to MSSQL 2008 without instance

I have 2 connections with node using the package mssql var config = { user: 'xx', password: 'xx', server: 'DESARROLLO\PROGRAMACION', database: 'prueba', options: { encrypt: true } } This work...
asked by 13.07.2017 / 22:49
1
answer

SQL query that returns dates that do not exist in the result of the query itself

I am working with a database in Informix. I access it from a web application developed with C #. In a table called MC_turnosAgenda I have several records, of which I want to obtain only the date field, using DISTINCT to obtain only once each...
asked by 10.07.2017 / 20:07
1
answer

Postgresql doubt field number

Good I need to enter high values for example 65.000.00 for the price of a product I have a Price field defined as Numeric (18.2) But it only allows me to enter values less than or equal to 999.00 as I would in this case?     
asked by 03.07.2017 / 01:04
1
answer

capture variable in a mysql trigger

Good evening really thank you for your time, I tell you  I have an expense table with several fields like idgasto, vendor, client, total and one more detail_gasto that has fields idgasto, idproduct until everything is fine, but the application i...
asked by 05.07.2017 / 08:10
2
answers

How do I save an array in the column of a database record, using PHP?

I'm doing it in the following way but in the bd it keeps me "array" and not the fix, can you help me please. <!DOCTYPE html> <html> <head> <script type="text/javascript" src="getmapa.js"></script> &...
asked by 30.06.2017 / 03:14
2
answers

Prevent a user from registering with an existing PHP SQL mail

Good, I recently re-programmed and I have a problem that is as follows: I have a database with the users table. that this table has mail, password, nick, photo_profile and id, the problem is that when registering users in the database, I can not...
asked by 30.06.2017 / 14:52
1
answer

Valid column name SQL Server-Python

I am developing a small application that depends on SQL Server and development in Python , this takes data of Sp of SQL Server that it has by default of name: xp_readerrorlog 6, 1, N'login', N'failed' As you see,...
asked by 23.06.2017 / 19:03