Questions tagged as 'sql'

Tagged questions
1
answer

Select columns from the records of another table

I have a question that I have not yet been able to solve. It turns out that I want to select the fields in a table. The problem is that these fields are not fixed but are stored in another table 'Table1' SELECT Campos FROM Tabla1 Campos --...
asked by 15.06.2017 / 19:23
0
answers

Connect website with sql server 2008

I'm starting to learn a bit of programming, and I try to make a record that connects to a sql manager studio 2008 r2 database. Everything is fine in terms of the local environment, the registry works just like the sql, but as soon as I upload th...
asked by 12.06.2017 / 02:13
1
answer

Fill a texfield from a combobox in EXTJS6

I had to continue a project and I have some doubts about EXTJS6 . It happens that the one who worked before used Sencha Architech, which I do not know how to use it very well so the files I have been seeing and understanding them by han...
asked by 06.06.2017 / 02:32
1
answer

Group by similar strings in MySQL

I am normalizing a database in MySQL and I have to convert a field that was entered manually to an FK field that is related to a new table that should have that manual income but without repeating it. The problem I have is that, being manual...
asked by 08.06.2017 / 00:48
0
answers

How to export to multiple worksheets in an ETL using Visual Studio [closed]

I am trying to export an excel file with two tabs or worksheets in an ETL using Visual Studio. I can not find anything on the web to help me. I attach the Controlflow and the Dataflow. Thank you!     
asked by 02.06.2017 / 16:29
0
answers

SQL field contains FieldTerminator

A BULK INSERT is made from a CSV file as seen below: BULK INSERT [bdc_sync_L].[dbo].[Libro_bibliografia] FROM 'D:\Data Center\Archivos\PRUEBA.csv' WITH(FIELDTERMINATOR = '|', ROWTERMINATOR = '\n') The problem is that a record has t...
asked by 08.06.2017 / 20:22
3
answers

Using IN or EXISTS in SQL SERVER

I'm doing a job for the university where I have to do a travel management system, where I have tables such as Pasajeros , Viaje , Boleto etc. Now I must make inquiries based on this basis that I created. A particular query...
asked by 09.06.2017 / 01:53
2
answers

BD Oracle query by time segments

Hello, I have a table in Oracle DB that has the following fields and values: Now I need to generate a query that groups me by sections of half an hour the number of elements per DATE_CREATION, for example for this case the result I would e...
asked by 12.07.2017 / 18:32
1
answer

bring information according to the user logged in mysql

I have a database with two tables, related to each other by ID. The T1 contains the entire record of a primary user, and T2 contains alternative users linked to the main user ID. What I need to do is that when an alternate user logs in,...
asked by 30.07.2018 / 03:56
1
answer

ERROR IN TRIGGER SQL BY MARIADB VERSION

I have inserted this trigger : DELIMITER // CREATE TRIGGER tr_updStockIngreso AFTER INSERT ON detalle_ingreso FOR EACH ROW BEGIN UPDATE producto SET STOCK_PRODUCTO = STOCK_PRODUCTO + NEW.CANTIDAD_INGRESO WHER...
asked by 26.06.2017 / 05:18