Questions tagged as 'sql-server'

Tagged questions
1
answer

Create a join with the results of stored procedures

Hello, I have two queries to return the result of two stored procedures DECLARE @return_value int EXEC @return_value = [dbo].[SP_TABLE_PRODUCTOS_ALMACEN] SELECT 'Return Value' = @return_value DECLARE @return_value1 int EXEC @return_value1...
asked by 08.03.2018 / 18:19
2
answers

DropDownList Asp.NET C # MVC

Then I leave the images (1,2). I have the BD "School" which has the Student and Group tables, and I want to add a DropDownList which shows the groups that exist in the BD and select it. I'd appreciate your help.     
asked by 30.03.2018 / 07:14
2
answers

using DISTINCT how can I check several records in a table? [closed]

I have the following query SELECT IdOcupacion, Codigo, Descripcion FROM Ocupaciones On which in the field of Descripcion I see several double registers and I would like to know how to consult only one of the registers but bring me th...
asked by 30.11.2017 / 15:50
1
answer

Display data from a sql server table in php with DataTables

could help me with an example and explanation of how to display the data of a query in a DataTable, for the moment it shows me the results in a conventional table. I have the following code: $query="SELECT art_Clave, art_Costo, kar_Fecha, kar_...
asked by 27.07.2016 / 20:23
1
answer

Insert problem using Visual Studio 2013

As you can see in the image, it tells me that I send null in dpi but I have filled these fields correctly in the form Some solution about it In the third image I can see the full picture as I've handled it Insert code...
asked by 25.11.2016 / 15:46
2
answers

Error when consulting with pivot

When making the query it generates an error which says that it does not recognize the name of the column t1.codigo or the name of the column t1.examen :    the identifier formed by several parts T2.CODIGO, could not be   link...
asked by 26.07.2018 / 15:23
2
answers

Add user inputs and outputs in SQL Server

I have the following SQL table: And I would need to get something like this: That is, add the hours grouped by date, I have tried different options, but not even close to the expected result ... Failed attempts: SELECT I...
asked by 17.07.2018 / 11:06
1
answer

Call a stored procedure of Insert Records

I have a stored procedure that inserts records into two tables at the same time. And I want that in the program, when you click on the SAVE button, you can call that procedure. How can I do that process? Thank you in advance. Here is my S...
asked by 28.05.2018 / 18:34
1
answer

Query with two types of INT and VARCHAR data

I have two tables from which I select a field of each for the query and fill in the datagrid only that gives me error because the id is in int type and the other is a string of type varchar in which it has several ids registered....
asked by 04.05.2018 / 20:16
1
answer

SQL Server and SQL Server Express

Spanish / Spanish. Hello everyone, as the title says, I'm confused about sql server and sql server express, being that I can not differentiate them, besides being able to install both in the same machine and use sql management studio. I as...
asked by 26.11.2018 / 01:34