Questions tagged as 'sql'

Tagged questions
0
answers

Use fields defined in EDM class improper of the database

I'm doing a procedure with which I want to transfer series to a place and show where they moved to perform the action of showing the data, I use a datagrid and the following query private void CargarGrilla() { decimal id...
asked by 30.11.2018 / 16:17
0
answers

External serial key is self-generated when inserting

I have a table "clients" : CREATE TABLE clients ( id serial NOT NULL, name character(25), user_id serial NOT NULL, CONSTRAINT "Client_pkey" PRIMARY KEY (id), CONSTRAINT clients_id_key UNIQUE (id) ) WITH ( OIDS=FALSE ); ALTER TABLE...
asked by 28.11.2018 / 17:21
1
answer

How can I make this structure in Json from SQL 2017?

I want to convert this structure by selecting data from the table when I select it, I am going to convert it into JSON from database Sql 2017. ATTACHMENT MY QUERY Select Medio_Pago AS [medio_pago] from Table_FacturacionElect where Comprobante...
asked by 29.11.2018 / 02:34
0
answers

Subquery returned more than 1 value.This is not allowed when the subquery follows =,! = , = , = or when the subquery is used as an expression

ALTER procedure [dbo].[GuardarTicketCombustible] @Proveedor varchar(300), @CentroCostos varchar(40), @Departamento varchar(40), @ConceptoGasto varchar(40), @ProductoGasto varchar(40), @Vehiculo varchar(40), @PeriodoAcomodo varchar(300), @Moneda v...
asked by 29.11.2018 / 02:23
0
answers

Validate client ID to export in SQL Server

Friends, good evening, I hope I can explain myself well about the problem I'm having. I am currently doing an export in SQL With the following query: SELECT IDFactura, FechaDocumento, NombreCliente, NIT, DireccionFacturacion, FOLIO, Sub...
asked by 29.11.2018 / 04:59
0
answers

JAVA - Save JTable in a SQL database

Create a program that allows me to save varied data in a JTable, but I would like to know how to create a button that would allow me to save the data in one SQL Table and another to call the data of that table (Export and import data).     
asked by 30.11.2018 / 01:49
1
answer

visual C # how to solve the saving of my output

It does not let me save the auto id incretable. What do I do? public string insertar(DRegistro_Salida registro_salida) { string rpta = ""; SqlConnection sqlCon = new SqlConnection(); try {...
asked by 30.11.2018 / 03:10
1
answer

How to place a variable as a pattern in the LIKE? SQL ORACLE

I am doing a project and I try to make a trigger which assigns the course number automatically. This is the trigger that comes to mind create or replace trigger TG_curso_Auto before insert on cursos for each row declare num_var int; begin...
asked by 26.11.2018 / 22:32
0
answers

SQL Server Linked Server

I have the following error when trying from linkear server to another SQL Server . TITLE: Microsoft SQL Server Management Studio ------------------------------ The linked server has been created but failed a connection test. Do yo...
asked by 26.11.2018 / 17:13
0
answers

An sql event can be conditioned

I have this event CREATE DEFINER='root'@'localhot' EVENT 'prueba' ON SCHEDULE EVERY 1 YEAR STARTS '2018-11-23 16:35:00.000000' ON COMPLETION PRESERVE ENABLE DO UPDATE cat_marca as tabla_c SET tabla_c.precio = (SELECT tabla_c.precio * tabla...
asked by 23.11.2018 / 23:34