Questions tagged as 'sql-server'

Tagged questions
1
answer

Python - The SQL Server server does not exist or access to it has been denied

The next string connection perfectly connects to the destination server: Import pyodbc cnn = pyodbc.connect('DRIVER={SQL Server};SERVER=MyServer;DATABASE=MyDb;UID=xxxx;PWD=xxxx') Print ("Conectado") But when I try to connect to an in...
asked by 21.11.2017 / 18:20
0
answers

ExecuteScalar SQL Server does not store an integer? C #

Good afternoon, I would like to know what I'm doing wrong because when I save the data through an insert, I keep the primary key with a very large value (it seems to be decimal) the table has the primary key as identity so that should be saved 1...
asked by 09.11.2017 / 20:15
1
answer

How to save the result of a sql server query on variables

Sorry for not explaining the question well. Many want to know what it is for: It is for a cost calculation report for a manufactured item, the costs are calculated from the lowest level and are added to the highest level. What happens is that I...
asked by 26.10.2017 / 18:17
1
answer

Search by numeric value sql net mvc2

I must filter the data by the address table data, it works fine with string but with int no. public ActionResult Buscar(string palabra) { IEnumerable<domicilio> domicilios; using (var bd = new serviexpres...
asked by 27.10.2017 / 20:58
1
answer

Dynamic Columns - SQL Server 2012

I have two tables which I want using a Query SQL Server to generate dynamic columns depending on the number of records in a table. Please see the image.     
asked by 03.11.2017 / 03:34
1
answer

Problem when saving a Visual Basic combo box data in SQL Server database

Good morning, I'm doing an insert from Visual Basic in a SQL Server database from a ComboBox that I'm filling from a database, at the time of saving the data, in the database me gurda the following: I have it in classes Insert compl...
asked by 25.10.2017 / 16:21
1
answer

Modify connection to SQL Server from Laravel 5.5 to manipulate dates

According to what Taylor says here in this commentary: link    You probably need to override the database link in the IoC and inject a custom ConnectionFactory implementation into the database administrator. Who can help me to do this?...
asked by 27.10.2017 / 00:44
1
answer

ASP .NET MVC Form with field "Image" - Load an image in the "View" and insert it into the DB

I have configured the connection to the database for the "Events" table Which generates me the fields in the model, and in the Image field transforms it to type "byte" public byte[] Imagen { get; set; } In the view I have the "Ima...
asked by 23.10.2017 / 02:48
0
answers

Insert data from a data grid view to a table in sql server from vb, net

Good afternoon I am trying to insert data from a datagridview in a database of slq server I have it by classes, here the classes if you could help me: 'Insertar quejas Function Insertar_Queja2(ByRef NUM_RECLAMO As String, PRODUCTO As Stri...
asked by 30.10.2017 / 21:29
0
answers

Error "DATE data type is not found" when executing query

I'm working on sql server and I have to put a field with the variable DATE but when I run the query it sends me this error: Columna, parámetro o variable nº 9: no se encuentra el tipo de datos DATE.     
asked by 23.10.2017 / 22:00