Questions tagged as 'sql'

Tagged questions
1
answer

CREATE TABLE error after IIS APPPOOL ASP.NET-SQL

I have a web application to mount in the IIS, the question is that when I try to visualize some view that uses data from the BD I showed the error of IIS APPPOOL\Licorera . Checking the internet to fix that error was to give the user pe...
asked by 25.05.2018 / 19:52
1
answer

Problems showing images [duplicate]

I have this code that prints images from the server, but I can only see it on the server and on the internet explorer only: <img src='file://192.168.10.129/sapshared/FOTOS/KennedyDB/$row[PicturName]' height = '100' width = '100' &g...
asked by 09.05.2018 / 04:09
2
answers

Help with SQL query

I have this query that brings me the people who marked that they want to do a course called "courtship" but what I would like to add are also those that marked other courses, for example "Finance", "Youth". this is related to answers.preguntaid...
asked by 09.05.2018 / 17:21
1
answer

how can I concatenate records from the same column in sql server?

If you could help me, I have a table like this: identificativo fecha 72028586 11/05/2018 72028586 13/05/2018 72045976 17/05/2018 72063798 13/05/2018 and I need to make a query to show me th...
asked by 21.05.2018 / 18:07
1
answer

Error in a trigger to erase rows

I have the following trigger: CREATE TRIGGER actualizarConsulta AFTER INSERT ON ranking FOR EACH ROW BEGIN DELETE FROM Consulta C WHERE C.jugador_id = NEW.player_id; END; When I try to execute it I get the following er...
asked by 28.04.2018 / 17:36
1
answer

How to enter a sql query in java, replacing hard code of a map?

I hope and they are well, I have a problem, what I need is to replace the hard code of a java map, for the results that an sql query returns to me, the hard code is this: { this.correspondencia=new HashMap<String, String>();...
asked by 26.04.2018 / 16:55
2
answers

Modify a date in SQL Server

My problem is that I want to add a certain number of hours and minutes to a date and save it. The problem is that it marks me an error in the type of data conversion. How can I modify this date so I can save it with the hours and minutes already...
asked by 30.04.2018 / 11:42
1
answer

Oracle Sql XE - Error entering sqlplus [Linux deepin (based on debian)]

I have a problem trying to login to sqlplus from the terminal. I run the sqlplus command, and then it asks for username and password. When trying to put system and the password that I put during the installation, I find the following error...
asked by 29.04.2018 / 02:23
1
answer

I can not add rows to a datagridview

I have a problem adding new rows to a datagrid I get the following error: "Can not add rows programmatically to the collection of DataGridView rows when the control is bound to data" The code I use to add rows is this: dataGridView1.Rows....
asked by 26.04.2018 / 18:04
1
answer

Inner Join Sub consultation

I am making a query which should return the client's code, name, years and the quantity sold. When I do not perform the filter (which shows me repeated results) I have no problem this is the query: select c.codigo_cliente, c.nombre, (to_number...
asked by 04.05.2018 / 09:03