Questions tagged as 'sql-server'

Tagged questions
0
answers

To install a software created by me I must install a BD [closed]

first of all, thank you very much for reading. I'm a novice really, I'm interested in making software, with C #, a windows application which works with its own database. To develop it I am using SQL Server 2014, my doubt is once I finish th...
asked by 04.05.2018 / 06:11
4
answers

How to call a stored procedure from the Entity Framework 6 code first

I'm trying to call this stored procedure from C # alter PROCEDURE GetLecturasEnRangoDeFechas -- Add the parameters for the stored procedure here @fecha as smalldatetime, @idParteMaquina int, @inicio int, @inicioMasDuracion int, @dia smalldatet...
asked by 11.01.2016 / 16:44
3
answers

sql query to delete from two tables at a time, SQL Server

I have two related tables, Ad_TypeConsulta and Ad_consulta, a type of query has several queries, I look for the sql script to eliminate both the type and the queries that belong to that type. DELETE Ad_TipoConsulta, Ad_Consultas FROM Ad_TipoCo...
asked by 28.04.2016 / 20:13
1
answer

SQLServerException: This driver is not configured for integrated authentication

Usage: Eclipse Oxygen SQL Server 2017 SQL Management Studio 17.3 Microsoft JDBC Driver 6.0 for SQL Server Java jre1.8.0_151 x64 Windows 10 x64 Every time I run my program I get the following error. Error:    SQLServ...
asked by 08.11.2017 / 22:13
2
answers

What does the = * mean in the where?

Good afternoon, I would like you to support me with this. I have a query select ... FROM DBSosst..SRG_SUMMARY_NAVIGATION, SALDOS_prueba1 a WHERE GROUP_ID = 4 and STRUCTURE_ID = 1118 and SUMTO...
asked by 06.05.2016 / 22:33
1
answer

How to generate a set of dates from a range?

I try to calculate the days of a range of dates, I have something of this style, however I get the amount of the range, my goal is to get the number of the day corresponding to the month. What it does Goal SELECT NOMBRE,R...
asked by 18.10.2018 / 22:18
1
answer

Correct CASE structure in SQL Server

I have the following query: SELECT *, CASE PORCENTAJE_CRUCE WHEN PORCENTAJE_CRUCE >= 80.00 AND PORCENTAJE_CRUCE <= 85.99 THEN 2000 WHEN PORCENTAJE_CRUCE >= 86.00 AND PORCENTAJE_CRUCE <= 90.99 THEN 3000 WHEN PORCENTAJE_CRUCE >=...
asked by 27.08.2018 / 15:16
1
answer

Replace characters in a field in SQL Server

My question is this, I have a field called titulo whose records are all university title names. Some contain ñ , other letters with accents. I imported it from a csv that already came with errors and my intention is to cle...
asked by 20.07.2017 / 20:46
1
answer

Concatenate values resulting from an INNER JOIN in a string separated by commas in SQL Server 2012

I have the following schema in SQL Server 2012: Tabla 1 Id INT PRIMARY KEY Descripcion NVARCHAR(20) Tipo INT Tabla 2 Id INT PRIMARY KEY Nombre NVARCHAR(80) IdTabla1 INT --Llave foranea a la primera tabla Tabla 3 Id INT PRIMARY KEY Nombre NV...
asked by 09.11.2016 / 15:52
1
answer

Create classes (class .vb) from a table created in MS SQL Server

I have a database created in MS SQL Server with different tables in it. What I'm trying to do is generate from this model "import" in some way to Visual Studio 2013 (Visual Basic - Framework 4.0) and generate classes automatically. For exampl...
asked by 10.02.2017 / 19:57