Questions tagged as 'sql-server'

Tagged questions
0
answers

Is the syntax of SQL server and MySQL totally different? [closed]

I have been reading a SQL book and have learned new things, however I want to know if the syntax of the sql queries are totally different from the ones that are done but in sql server, for example the syntax to do an inner join in sql is differe...
asked by 11.05.2018 / 07:59
0
answers

SqlBulkCopy: Error in ColumnName

I want to implement the use of SqlBulkCopy to reduce the insertion times in a migration I'm doing from a system. In StrArray(x) I get the name of the columns as they are in the table where I want to insert the information, which I st...
asked by 17.04.2018 / 01:44
1
answer

Convert several tables to json from a query in sql

Well I have not been able to achieve the conversion that I need and it seems to me that on this side I could work. Having already generated these classes with link public class ProductoConsultaJ { [JsonProperty("text")] public string...
asked by 14.03.2018 / 02:37
0
answers

Add the GROUP BY clause

I am working with SQL Server 2014 Express Edition and I have the following query. SELECT DISTINCT T.ProductoCatalogoId AS Id, T.ProductoId, CONCAT(T.Nombre, ' | ', T.TALLA, ' | ', C.COLOR) AS Descripcion, T.PrecioVenta, T.CATALOGO AS Nombre FR...
asked by 11.12.2018 / 18:10
2
answers

Select records that exist less than 3 times in a table

Hello, I have the following select: select u.idusuario, u.apellido, u.nombre, u.login, u.email from USUARIO u left join CREDENCIAL c on u.idusuario=c.idusuario where c.idusuario is NULL Which is useful to bring the records that do not ex...
asked by 03.05.2018 / 23:08
1
answer

How can I send Excel from sql server?

Good Night. I'm exporting an excel file to my email from SQL SERVER 2012 Why, if it generates me and my email arrives to me the excel the bad thing is that it comes out in a single cell as the image that I attached Would there be a way to for...
asked by 18.01.2018 / 01:12
1
answer

Error with SqlSysClrTypes.msi when trying to install my application in C # and SqlServer

I have an application developed in C # with SqlServer 2014 and I have the database included in the project. When I install the program on my pc I have no problems and the program works correctly. The error appears when trying to install the ap...
asked by 26.02.2018 / 00:42
0
answers

Security in my connection SQLServer and VB.NET [closed]

My question is to check if my connection is guaranteed to alleged attacks or is vulnerable to aspects that I can not identify. The structure that I manage in my projects is the following:    Connection class. Imports System.Data.SqlClie...
asked by 01.09.2018 / 18:21
1
answer

MyBatis update timeout does not run

When I execute an UPDATE in MyBatis it hangs, if I put timeout "20" it interrupts the execution due to the excess of time. Mapper: <update id="actualizarUnaSalida" timeout="20"> UPDATE dbo.TbSALIDAS SET Facturado=1 WHERE...
asked by 28.06.2017 / 12:33
0
answers

Generic queries in SQLSERVER [closed]

Good morning I would like to know if someone has ever done something like an IDE of sql server from C #. Let me explain, I have created an environment of SQLServer Web (In MVC), for remote administration, and I have all the visual part, I am...
asked by 10.04.2017 / 20:50