Questions tagged as 'sql-server'

Tagged questions
1
answer

Import EXCEL file (xlsl) to Table

What I need is to be able to load the data of an Excel sheet to a table. I already tried with bcp. Also with Bulk Insert and finally enabled: sp_configure 'show advanced options', 1; RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries'...
asked by 17.10.2017 / 18:19
0
answers

Error # 8134 (Divide by zero error encountered) - SQL Server database replication

When trying to create the snapshot of X database in a transactional replication the error appears:    "Message: Divide by zero error encountered Stack: (Source: MSSQLServer, Error number: 8134)" When looking at the replicatio...
asked by 11.10.2017 / 18:11
0
answers

java.lang.IllegalArgumentException: adding a window to a container

I'm trying to insert a design of a frame to put it inside a Jlist, but it throws me this error java.lang.IllegalArgumentException: adding a window to a container public class clsRender implements ListCellRenderer, Renderer{ private final JTex...
asked by 13.10.2017 / 04:13
2
answers

How can I load the path of an image to the sql server from visual studio using c #?

I'm doing a Windows Forms project in Visual Studio 2015, with a database in SQL Server Management Studio 2013 and I want to be able to add an image from a project form and keep the same route in my database. data. if (ValidarDatos()) {...
asked by 09.10.2017 / 20:05
0
answers

Consult WebService

Good afternoon, I have the following data in a table in Sql Comprobante Categoria 603552 A 624997 A 651880 A 672298 C 615985 C 613804 C 617970 A 625688 A 68946...
asked by 08.10.2017 / 23:17
1
answer

Do you know the cause of this error?

Good evening, my doubt is as follows, I have a website created on asp.net that is working with a SQLServer DB but at the moment of executing my code this error is resulting and I have tried to find a solution but I can not find What is causing t...
asked by 06.10.2017 / 03:00
0
answers

Get a report of where the QUERY falls exactly - Transact SQL

I have a query that throws me an error because it returns more than 1 value "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."...
asked by 13.10.2017 / 22:25
1
answer

Asp.net mvc 4 ado.net or lambda?

Dear, I am just starting on asp.net mvc 4 programming and the truth is that I feel somewhat lost. I come from working on Windows Forms and ASP.Net N layers, which used ADO.Net and it made it easier for me to create my Stored Procedures in S...
asked by 13.10.2017 / 23:45
1
answer

how to extract rows from sql table field in String with C #?

Good morning, I would like to know how I can extract all the rows of a certain field in variables (String) using C #. For example: Campo = Usuario rows of said field: Juan Ana Jose put them in variables like this: String nombr...
asked by 02.10.2017 / 07:43
1
answer

Compare data from two SQL Server databases with VS2013

Visual Studio Ultimate 2013 gives you the possibility to compare Sql Server data between two databases and then synchronize them, I need to make that comparison and synchronization automatically and if it is in a better Wimdows Services, can tha...
asked by 02.10.2017 / 18:49