Questions tagged as 'sql-server'

Tagged questions
0
answers

Two ComboBox related in a DataGridView in Visual Studio 2012

I have this code with a DatagridView and two ComboBox, one Province and the Other City, I need that when choosing the province in the first combo, the second combo shows me the cities corresponding to that province Imports System.Data Imports...
asked by 17.08.2017 / 17:31
1
answer

Error installing SQL Server Managment 2008 Express

I already tried everything and I did not succeed with the installation, so I come to you to see if you can help me. Problem: Unable to install SQL Server Managment 2008 Express. Error: "Error 1911.Could not register type library for fi...
asked by 26.07.2017 / 14:49
0
answers

Implement login using SQL Server credentials in ASP.NET - MVC

Good morning, I am working on an application with ASP.NET - MVC and SQL Server. I do not have much experience with these technologies, so my question may be a product of my lack of instruction. Can a login be implemented in the applicatio...
asked by 03.07.2017 / 18:54
1
answer

Select columns from the records of another table

I have a question that I have not yet been able to solve. It turns out that I want to select the fields in a table. The problem is that these fields are not fixed but are stored in another table 'Table1' SELECT Campos FROM Tabla1 Campos --...
asked by 15.06.2017 / 19:23
0
answers

Conflict with MSDTC and Windows Server 2008

I have 2 servers (one for applications and another for database) with Windows Server 2008 R2 and SQL Server 2008 R2 . I have installed an application developed with C # .NET Framework 2.0 and 2 Databases, I use TransactionScop...
asked by 21.06.2017 / 06:46
1
answer

parametrized sql query

Write a query that shows the last name (with the first letter in uppercase and the others in lowercase) and the length of the last name of all employees whose name starts with L, P or R. Label each column appropriately. Sort the results by the l...
asked by 13.06.2017 / 19:44
1
answer

Problem when loading data in a table

I have the following page: <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <div class="row-fluid"> <div class="col-lg-12"> <h4 class="page-header">Productos</h4...
asked by 19.06.2017 / 20:02
1
answer

SQL SERVER Cross Reference for months

I have this Cross Reference Consultation that gives me the units per month and year and it works perfectly, what I would like is to be able to add all the months in the same Row as Total, being able to add [1], [2], [3 ] .... At the end of the r...
asked by 28.05.2017 / 11:00
0
answers

SQL field contains FieldTerminator

A BULK INSERT is made from a CSV file as seen below: BULK INSERT [bdc_sync_L].[dbo].[Libro_bibliografia] FROM 'D:\Data Center\Archivos\PRUEBA.csv' WITH(FIELDTERMINATOR = '|', ROWTERMINATOR = '\n') The problem is that a record has t...
asked by 08.06.2017 / 20:22
0
answers

Must declare the scalar variable "@pList"

I need to pass a list of Id's to WHERE of a UPDATE , iterating and doing a UPDATE at the same time, these I get from doing INSERT to a table type TYPE with a value as type INT . Something like this: D...
asked by 12.05.2017 / 23:29