Best answeres tagged with sql-server

2

answers

Problem with SQL Server queries

I have a database of students of a university in which each form corresponds to a particular subject. The DER (Relationship Entity Diagram) is the following: and I have problems with the following statements to solve: 1) Show the st...

asked by 26.06.2017 / 00:11

1

answer

The content of DropDownList with Entity framework can not be saved in a bd

I am using the Entity framework for data persistence, I want to save an id (the field is of type identity), a name and the gender of the person, but when I click on save, it throws an exception to me Error de servidor en la aplicación '/'. Val...

asked by 09.06.2017 / 05:50

1

answer

How can I fix the error: Parameter is not valid

I have an error that does not let me show the image saved in the database but I can not find how to fix it. It says that the error starts from: PictureBox1.BackgroundImage = (Image.FromStream(mStream)) My code is: Private Sub Mostrar...

asked by 19.07.2017 / 23:32

1

answer

Update field with a specific condition with trigger

I have the following situation I would like an idea of the condition that could be put in a trigger so that when you insert an ISR422 for example 1.1 the date is updated automatically of the one that has an isr422 = 1, that is, both would have t...

asked by 20.07.2017 / 22:55

1

answer

Is it possible and how to transpose results from a column to rows dynamically? SQL Server 2008 R2

asked by 03.07.2017 / 18:29

1

answer

Error connecting to an Azure SQL database from a Vb.NET Winforms application

I have an application made in visual studio 2015 with winforms and visual basic which works with a database on a SQL Server 2008 R2 server that is located within the same local network of clients. I currently want to migrate the database so t...

asked by 25.07.2017 / 23:03

3

answers

SQL Server 2014 Job

I need please if you can give me ideas on how to solve the following: I have a database that I will call Principal that is in SQL Server , it imports information from other databases ( Oracle and SQL Server ) to show...

asked by 05.05.2017 / 21:01

1

answer

Function Update Massive sequelize - Node

Good, I am trying to make a massive update to an MSSQL database from Node using sequelize. I still do not understand very well all this of the Promises, .then () etc. What I'm needing is a function called by POST, which receives an array of J...

asked by 30.05.2017 / 18:12

2

answers

Query with related tables in SQL and C #

I have this form: This form feeds two tables in the database projects and students , all right up to that point, since records are kept, both new projects, and students by separated. What I do not have very clear is in assigning stud...

asked by 11.03.2017 / 23:23

2

answers

Visual Studio 2010 does not run the project [duplicated]

What happens is that in my development team a project is being carried out, Tortoise is used to keep the repository updated. On my laptop, the project does not start, however, on my colleagues' computers, yes. The project is located following...

asked by 09.02.2017 / 19:17

Questions tagged as 'sql-server'