Questions tagged as 'sql-server'

Tagged questions
0
answers

error with rank on sql server

I have this query on sql server: SELECT distinct(em.id_empleado), al.region, al.des_almacen, al.cadenaventa, em.des_empleado, em.cargo, em.pais, al.id_almacen, T1.ventas, T1.boletas, T1.unidades, T2.trafico, RANK() OVER (ORDER BY T1.boleta...
asked by 21.11.2018 / 20:18
1
answer

Equivalent FileInputStream in PHP

I would like to pass a PDF file to a binary text string to store it in a field of a SQL Server database (VarBinary). The Java code that is responsible for storing it is the following: FileInputStream fis = new FileInputStream(doc); stmt.s...
asked by 21.11.2018 / 14:11
4
answers

SQL - Query max value of a group by three columns

What I'm trying to do is that the query returns me from the value of the numberPurpose column of a data group in the SequentialGarantia column, but depending on the maximum value of > Initial debt . Desired result: What I did...
asked by 21.11.2018 / 18:00
1
answer

Syntax error near "Else" SQL Server

Good evening / days / evenings. I have been doing a stored procedure in which I insert data if it does not already exist within the different tables. The problem is that I have the idea of how to do it but now I have a problem that is the fol...
asked by 19.11.2018 / 05:31
0
answers

HOW TO EXPORT PRIMARY KEYS TO MAKE RELATIONSHIP BETWEEN TABLES

I have a problem, I need to export the primary keys of three tables to a new table to be able to relate these three tables, I know how to do the foreigner but that export term confuses me a bit. I hope you understand my question. There I send...
asked by 26.10.2018 / 07:00
0
answers

Image processing with WEB REST C #

I am making a mobile application with Android Studio and I synchronize it through a WEB REST in C #, the problem is that when synchronizing the images between SQLite and SQL Server, it sends me an error in the data types in my Web Rest. I clarif...
asked by 29.10.2018 / 20:08
1
answer

Daily exports in SQL Server Express

I have the following query, I have previously made several information exports from SQL Server Standard or Enterprise, when these versions of SQL have been I have not had much problem since the SQL Server Agent is the ideal tool to do it through...
asked by 16.10.2018 / 19:36
0
answers

Error with SqlTableDependency when making requests every second

I am migrating to SqlTableDependency to get notifications of changes to the database on my asp.net mvc web system. Previously, I used SqlDependency to get the notifications, but I found it more useful to do that migration. The problem is a li...
asked by 31.10.2018 / 20:50
0
answers

What are the disadvantages of using a varchar (max) MSSQL field? [closed]

Currently, I work in the support of a web application where users place orders, the system works great, but there is a section in which we have had difficulties, the blog, when a user registers an order is used var jsonSerialiser = new JavaSc...
asked by 19.10.2018 / 18:37
1
answer

ERROR when sending variable to php and capturing php array in jquery

I'm doing a car complete with jquery, php, sqlserver. I send a data to the file search-client.php with ajax but I can not get any results back and I can not see any kind of error in the browser. JQuery code $(document).ready(function(e)...
asked by 25.10.2018 / 14:34