Questions tagged as 'sql'

Tagged questions
4
answers

count of 2 tables in mysql

I have 3 tables in mysql, one is customer, another store and reserve, this is related to the customer table and steals the id and the store tbl and also steals your id, my question is, how can I make a list of all the clients and know how many r...
asked by 08.07.2017 / 00:51
1
answer

AJAX error when sending data with files

Hello, I am trying to upload a file from exel to a database / SQL SERVER 2008 through AJAX . But I have a problem with the file when I send the data ... at this moment I have not managed to mount the file in the query to execute it, on the...
asked by 10.11.2017 / 22:51
1
answer

Update the prefix of a field

I need to change the prefix of one field to another for all records before a date. UPDATE tabla SET campo1 LIKE 'YYYYYYY%'; WHERE (campo1 LIKE 'XXXXXXXXXXXXX%' AND FECHA<DATE('2017-04-05')); The following error report appears: Error SQ...
asked by 27.06.2017 / 13:34
2
answers

Count in sql query

I'm trying to count the number of locations (SELECT COUNT(t.SI_Ubicacion)) AS cantidad, SELECT t.SI_Articulo, m.SI_Descripcion, t.SI_UM, (CASE WHEN c.SI_OV IS NOT NULL THEN '*' ELSE NULL END) AS SI_OV, (SELECT COUNT(t.SI_Ubicacion)...
asked by 27.06.2017 / 17:00
1
answer

How can I implement this in the database?

Good, this is what he asks me for a table emple-depart-presupuesto We must ensure that the spending on salaries of a department does not exceed 50% of the current budget. CREATE OR REPLACE TRIGGER SALARIO50 BEFORE INSERT OR UPDATE ON emple...
asked by 14.06.2017 / 00:11
2
answers

Group records in a table

I have the following query: SELECT * FROM tabla1; So it shows this: Empresa | Empleado -------- --------- pepsi | jose -------- --------- pepsi | pedro -------- --------- pepsi | juan What I want you to show is this: Empresa |...
asked by 12.06.2017 / 15:02
1
answer

SQL error: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'Administrator'. at

I have the following error on my SharePoint page and I try to connect to a database but I get an error. I do not know what to do since I have administrator privileges SqlConnection conection = new SqlConnection(@"Data Source=SHAREPOINT\SHAREP...
asked by 09.06.2017 / 03:29
1
answer

UPDATE variables and data in PHP and MySQL

I need to save a path of an image in my code, in case the user does not want to modify the image when modifying a product. The current problem is that it sends blank and modifies the url of the image in the database <?php session...
asked by 17.08.2017 / 02:37
3
answers

SQL query with String data

Hello, I have a query SQL implemented in JAVA in which I need to insert the values MTILM, MVisual, MVerba, MAR, MTeorico whose data is of type String, here I leave an example connectionDB.executeInsertUpdate("INSERT INTO 'data_process...
asked by 01.06.2017 / 21:37
2
answers

Error doing Left Join. The identifier consisting of several parts ... could not be linked

First of all, explain what I am trying to do so that you understand my problem. I am developing a web platform based on PHP to perform the maintenance of the different types of equipment that may be in an empesa (High, low and modification there...
asked by 18.05.2017 / 11:08