Questions tagged as 'sql'

Tagged questions
1
answer

Send parameters for SQL command as parameterized variable

I need to send the parameters that I will use in a sql command, I know that it can be done with Dim paramater As New SqlParameter("@fptemp", serializedTemplate) but now the problem comes when I use a parameterizable function to execute th...
asked by 28.02.2017 / 21:20
1
answer

Doubt with pivot table in access

I have this query in access, but I can not sort the Format ([DateCob], "mmmm") by the order of the months, they are sorted by alphabetical order (April, August, December, etc.) and I want it by order of months (January, February, etc.) This is m...
asked by 06.02.2017 / 03:54
2
answers

Constraint or trigger greater than 18 SQL

I need to check when adding a "voter" in the database if it is over 18 years old, I have tried it with a constraint and a check, but it does not support functions for the current date. What other options are there? ALTER TABLE votantes ADD CON...
asked by 30.01.2017 / 11:04
3
answers

Fill an array of Javascript with the result of a SQL Server stored procedure

I have a stored procedure which, when executed, throws me a table dynamically. I would like that table to be stored in an array of Javascript, regardless of the number of fields or rows. Is there any way to fill in from a SQL Server stored pr...
asked by 18.02.2017 / 01:27
1
answer

How to send data from a dataGrid that is constantly changing to an SQL table

is constantly changing because it gets its information with different excel files.  with this code. public partial class PM : Form { private BindingSource bindingsource1 = new BindingSource(); private SqlDataAdapter dataAdapter = new S...
asked by 30.03.2017 / 18:48
1
answer

Store procedure oracle with several queries at the same time

Hi, I want to run 2 queries on 2 different tables with a single store procedure. BEGIN UPDATE personal SET imei_equipo = v_imei WHERE PERSONAL_ID = v_personal_id; BEGIN UPDATE lugar SET latitud = v_latit...
asked by 03.02.2017 / 21:09
2
answers

Perform join on a table depending on the value of a field

I'm trying to make a query in Mysql and according to the column type of my table reports, make a JOIN to one table or another. Reports: In type the type of the item to which it is reported is stored, whi...
asked by 03.02.2017 / 23:24
1
answer

Get OUTPUT of Stored Procedure

I have for example this stored procedure ALTER PROCEDURE dbo.PersonaDoc @cDocumento varchar (20) AS SELECT Ruta_Line FROM Persona WHERE (documento= @cDocumento) What difference would there be to consuming it in C # using ExecuteNonQuery, E...
asked by 03.02.2017 / 20:05
2
answers

SQL select one thing from two different tables in the same query

Good, I have two tables, one is called PERSONAL and the other TASK, and I do not know if it is possible through the JOIN operator to select the field "name" of the PERSONAL table and the "description" field of the TASK table that has a certain i...
asked by 23.02.2017 / 20:02
2
answers

Backup Mysql - JSP

It's the first time I try to make a backup of a BD Mysql from a JSP This is my code (In some forum I saw it). <%@page import="java.sql.*" %> <%@page import ="java.util.Calendar" %> <% try{ Calendar fecha = C...
asked by 19.04.2017 / 19:06