Questions tagged as 'sql'

Tagged questions
1
answer

SQL - Filter by range dates with double column

Hi, I have a problem with a query. I want to filter by date ranges with two columns. Start and End. X | Inicio | Fin 1 |2018-10-01 | 2018-10-31 2 |2018-11-01 | 2018-11-30 3 |2018-11-15 | 2018-12-15 Inicio BETWEEN @parametroInicial...
asked by 23.11.2018 / 17:14
3
answers

Syntax error when updating data in MySQL

I'm trying to update a user's data in mysql. Someone can identify me why I get the following error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'di...
asked by 30.11.2018 / 11:04
1
answer

Warning: mysqli_fetch_assoc () expects parameter 1 to be mysqli_result, boolean given in C: \ xampp \ htdocs \ modif_pro.php on line 10

<?php $consulta = consultar($_GET["ruc"]); function consultar($ruc_prov){ include("Conexion.php"); $s="SELECT * FROM productos WHERE no='".$ruc_prov."' "; $rs= mysqli_query($enlace,$s); $filas = mysqli_fetch_a...
asked by 17.11.2018 / 12:48
1
answer

UTF-8 Does not accept special characters PostgreSQL-SQL

Good morning I have created a database to store all the countries and cities and I am trying to load the data but even though my database is created with a utf-8 file like my tables. At the time of importing I also select UTF-8 but it gives me e...
asked by 15.11.2018 / 14:28
1
answer

How to upload CSV file to SQL Server with SSIS

Hello dear, I hope you can help me. I am developing a workflow in SSIS to load Excel 2010 files into a table in SQL Server 2008-R2, many of the fields in Excel have text of more than 255 characters and are sometimes truncated in that value,...
asked by 07.11.2018 / 00:32
1
answer

Use Multiselect bootstrap "Does not show accents"

I do not know what I have to confirm to show me with an accent what I put in the nonSelectedText onInitialized: function($select, $container) { }, enableHTML: false, buttonClass: 'btn btn-default',...
asked by 08.11.2018 / 22:50
1
answer

PostgreSQL, stored procedure to update a table

I am creating a stored procedure to update the data userid of the table clients based on the id of the client cid ; but so far I have not succeeded: the function does not update the userid of the client. CREATE O...
asked by 04.11.2018 / 18:22
2
answers

Group records by column without the null value (Sql Server)

Dear friends, I have the following query: IF OBJECT_ID('TEMPDB..#TOTALHORAS') IS NOT NULL BEGIN DROP TABLE #TOTALHORAS; END SET LANGUAGE SPANISH; CREATE TABLE #TOTALHORAS( EMPLSECCION VARCHAR(100), EMPLMINUTOS VARCHAR(100), EMPLMINUTOSN...
asked by 16.11.2018 / 21:43
3
answers

How to show in jframe the results of the sql statement?

I would like to know what I am doing wrong in the code, it turns out that I try to get the data of the statement sql in the JFrame . I leave the code what I have package Formulario; import Formulario.Menu; import Clases.*; import jav...
asked by 25.06.2016 / 02:16
1
answer

How to convert kilobytes to varbinary?

Whenever I need to store files in a database I use the varbinary (max) field, which is the maximum that the data type supports, and I simply assign a byte array to the field to store it, at this moment I am in the same situation and I have a que...
asked by 23.06.2016 / 21:11