Questions tagged as 'sql-server'

Tagged questions
1
answer

Error executing update with subquery

I have the following situation, I need to perform an update on several fields based on the return of a subquery that returns a main code. This subquery is done with join in two tables to get the code. While doing this, I get the following error:...
asked by 11.12.2018 / 19:21
2
answers

How to include data from a multiline query in a memo using Delphi?

Good afternoon. I work on a legacy system and need to put information from a query into a single memo object. Code follows. MyQuery.Close; with MyQuery.SQL do begin clear; add(' select TOP 8 nuentrada, dstpleitu, vlleitura, ds...
asked by 03.12.2018 / 18:10
1
answer

How to download SQL Server file using Servlet

I have a basic application where I save files in the database SQL Server using Java , the insert part in the database I already did, I would like to know how do I to download the file that is in the bank via JSP . As stored...
asked by 18.12.2018 / 20:57
0
answers

SQL trigger Updates Stock

PRODUCT LIST create table LISTA_DE_PRODUTOS ( IDPRODUTO numeric identity, PRECO money null, DESIGNACAO varchar(50) null, ALCOOLICO bit...
asked by 11.12.2018 / 02:01
0
answers

How do I do the infinite scroll do not load the same values again?

I have the following code: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js"type="text/javascript"></script> <script> $(document).ready(function() { $("#content").scroll(func...
asked by 23.11.2018 / 13:05
0
answers

Join in 3 tables

I need my query to return who is the direct partner of the company "Father" and the company "daughter". I got him back to the daughter company and the direct partner, but I need him to get me back if the daughter company has a partner. can anybo...
asked by 02.12.2018 / 19:01
2
answers

Merge column data inline - SQL Server

I have the following situation: Usuario_A telefone1 Usuario_A telefone2 Usuario_A telefone3 How can I do that when I make a select, have the following output: +-----------+----------------------------------+ | Usuario_A | tel...
asked by 08.11.2018 / 17:08
1
answer

How to extract the SQL Server log file from the server?

I have a SQL Server and I need to send the Log file to one of our Clients, however this file has 24 gigabyte, How to extract this logo file in csv format?     
asked by 08.11.2018 / 14:21
1
answer

SELECT lock when I make an UPDATE - SQLServer

I'll give an example of what I'm doing, but the very question is at the end. I have a table with 4,100,000 records and I am creating a theft that reads this data and exports it to MYSQL (it does not enter into the agenda, just to set it up)....
asked by 08.11.2018 / 13:41
0
answers

Problem in connecting DB manager on Ubuntu 18 machine with SQL Server (cloud)

The situation: I started looking after a PHP application implemented in Codeigniter 1.0 (Linux server) that accesses SQL Server 2008 databases (Windows server, in the cloud). I have a development machine, dual boot (DEV Ubuntu 18 and DEV Wind...
asked by 26.10.2018 / 19:52