Questions tagged as 'sql'

Tagged questions
1
answer

Error creating and executing stored procedure

I am trying to create a stored procedure which verifies all the projects in my database and gives me for each project a series of elements that I need. When trying to do this, the procedure bugs me with an error Must declare the scalar var...
asked by 24.04.2017 / 21:34
1
answer

IDENTITY_INSERT error in SQL

My problem is that I try to make a simple insert in my Database, but at the moment of executing the sentence it marks me the following error:    An explicit value for the identity column in table 'tNationalization'   can only be specified whe...
asked by 30.03.2017 / 00:33
1
answer

problem error query mysql delivery null values

hello I have an sql query and when the execution happens it gives me null values I do not know why they would be able to see if there is any error, all the tables have data tables participants enrollment solo_curse generic_course...
asked by 27.03.2017 / 21:26
1
answer

Pass an instruction from sql to an asp: SqlDataSource

I have the following statement tested on the sql server: select AsignaturaNombre from Asignatura where CodigoAsignatura=(SELECT [idMateria] FROM [Permisos] WHERE ([idProfesor] = 19398676) union SELECT [idMateria] FROM [Permisos] WHERE ([idAlum...
asked by 24.03.2017 / 15:27
2
answers

How to join two queries in sql for me to total?

Hello friends, I'm here to request your important contribution I have this Script SELECT ISNULL(mes,0)[mes], ISNULL(Cod_Area,0)[Codigo Area], ISNULL(nom_emp,0)[Nombre Empleado], ISNULL(Cod_Puesto,0)[Codigo Puesto], ISNULL(Puesto,0)[Puesto], I...
asked by 10.03.2017 / 17:23
1
answer

decimals oracle sql

I have a question, I have in database a data of type number(5,2) but I have values with 1 1.1 3.18 The question is, in the query I can have the zeros added to the right so that the data comes out 1.00 1.10 3.18 the base is oracl...
asked by 10.03.2017 / 00:46
2
answers

Problem with INNER JOIN

I am using INNER JOIN to list the demos and its descripcion , but now I need to add to this info the tags which are saved in a table tags with a name and a demo_id that would be the way to associat...
asked by 21.03.2017 / 22:02
1
answer

How to get a value from a SQL Server T-SQL record

I have the following code USE [database] GO /****** Object: StoredProcedure [dbo].[spPacienteEnCola] Script Date: 02/23/2017 08:31:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spPacienteEnCola] @ta...
asked by 23.02.2017 / 18:31
2
answers

Show columns that have SQL SERVER value

Good I have this table that has as 100 columns as the image and the query but what I want is only to obtain the columns that have amount just choose these columns: Numero prestatamo NumeroCuota Fechavencimiento columns that have an...
asked by 21.02.2017 / 23:05
2
answers

How to regroup 2 JSONs for a given position? I put 2 examples to show what I want

I have 2 examples of the select that I want to generate a good one and a bad one. There you will see. $(document).ready(function() { var result_malo = [ [ { "id": 1, "nombre": "Bocina" },...
asked by 16.02.2017 / 15:54