Questions tagged as 'sql'

Tagged questions
0
answers

How can I insert multiple records in a single stored procedure?

Hello, how are all my questions? Is it possible to send a stored procedure in this way: CALL SP_CLIENTE((1,'pepito','perez'),(2,'alan','brito')); for (let i = 0; i < xml.length; i++) { datosJSON.push({ 'id': info.replac...
asked by 06.06.2018 / 18:45
1
answer

Use long text in sqlite3 Database

I'm doing a program in C ++ in which I use a SQLite database. I have attributes of type string that I save as text. The problem is that when these strings are of great length, do not insert or read as you should, but other characters appear, des...
asked by 03.06.2018 / 16:56
0
answers

Comboboxcolumn datagridview c # sql server

I am working on a project on c # and sql server. When selecting an item from a comboboxcolumn, you must bring me the description and price from the database, if it does, but it marks the following error. I have these events private vo...
asked by 01.06.2018 / 03:45
1
answer

Problems importing MySQL database to WorkBench and PHPMyAdmin

I'm trying to import a database MySQL , both through WorkBench , and PHPMyAdmin , everything runs correctly, but it does not matter absolutely nothing. Imported in WorkBench Imported PHPMyAdmin    Messages in red...
asked by 01.06.2018 / 07:42
0
answers

import query with sql pivot to excel

I have a query in sql with pivot that returns the dates in columns, I want to make that query empty in an excel sheet to be able to do operations but for some reason excel it does not matter the data can guide me and more than anything know if p...
asked by 08.06.2018 / 03:31
0
answers

"Select from (Select" Subquery a doctrine dql

I have made a query to the database to get the actual availability of the rooms of several hotels but when trying to make the query with doctrine in symfony 3.4, I get an error. This is the query: SELECT (CASE WHEN count(_days) > 0 THEN...
asked by 08.06.2018 / 10:39
2
answers

Unknown column in 'on clause' - SQL Error (1054)

First of all indicate that I have tried to find my answer here but I can not find any example that resembles mine. I want to get the data from an activity table with its corresponding documents, but the ACT table is apparently not visi...
asked by 08.06.2018 / 09:09
1
answer

remove product from product table that is related to sales note

Hi, I'm a newbie in web programming and I just finished my first website in my professional practice and the company was satisfied, only my question is for example I have my BD which has a table related to a table. sale, the doubt in particular...
asked by 31.05.2018 / 05:47
0
answers

Help with a query group data

Hello I have a database and I want to group some data, the database is structured as follows Lote | Surtio | Lugar | Fecha All are string type, and I have the following query SELECT surtio , lote FROM filtrado where linea = 'pi...
asked by 01.06.2018 / 17:49
1
answer

Place the value of one column in another column of different rows

I need to create a select where it is placed in value of one column in another column which belong to different rows, using the criteria of the type column. In other words, place the value of column_one in column_dos when type is = 'B'. Type...
asked by 01.06.2018 / 01:35