Questions tagged as 'sql-server'

Tagged questions
0
answers

Properties button not enabled

I have the following situation. I made a default installation of SQL SERVER Reporting Services 2012 and followed the steps in this link to perform the first basic configuration of accesses. link After this tutorial, I accessed the reporting...
asked by 22.01.2018 / 14:40
0
answers

How can I not freeze / crash the application when querying data via SQL Server and creating a "progress bar"?

The code below as an example brings me great information from the database. Every time I click on the "Search" option of my program, my application freezes / hangs for a while until the select "pull" everything. I would like to know how best to...
asked by 22.01.2018 / 13:58
0
answers

Sequence currval

I have two tables: Create table fornecedor(codigoFornecedor INTEGER NOT NULL, nomeFornecedor NVARCHAR(45) NOT NULL, telefoneFornecedor VARCHAR(15) NOT NULL, PRIMARY KEY (c...
asked by 22.01.2018 / 11:46
1
answer

SQL-SERVER query optimization

I need to get the EMISSION_DATE field of TLX_VENDA and the B9_DATA field of the TLX_ESTOQUE_INI table, however I need to do this within OUTER APPLY . I managed to get into the result but it is very slow. Here...
asked by 02.02.2018 / 13:16
0
answers

Datagridview does not store information in the table

I have a datagridview that is fed by a search in a database to hold a sale but I can only sell one product at a time because the sales chart can not receive 2 or more products simultaneously already tried to separate the sales table into 2: sale...
asked by 20.01.2018 / 01:21
0
answers

Failed to Deploy Report with Reporting Service

I have a report developed with SQL Data Toosl but when I try to implement it I get the message that the server was not found, but it is configured in the properties of the report. Follow how you are today. This is the URL implemented in the R...
asked by 19.01.2018 / 22:18
1
answer

limit users in the database

I searched and did not find out how to do to limit users in a DB ... I'm trying to make a C # application using 'sql server' and would like to know how to make userDB have a maximum of 5 users, when trying for the 6th user the system warns that...
asked by 22.01.2018 / 19:45
2
answers

Filter table data

How to select only part of the record from a table? Source data: "brt_qsr01:NT" and I intended it to return only qsr01 I'm doing this, but then I can not remove the data on the left SELECT left([coluna], CHARINDEX(':', [col...
asked by 19.01.2018 / 17:06
0
answers

Query - SQL Server with stuff

Please, in the query below I want you to bring it as follows. contato andreia, marcos, juliana ie on the same line. In the query, I used stuff , but to no avail. Today she's bringing it that way. contato andreia marcos juliana...
asked by 23.01.2018 / 16:11
0
answers

how to see SQL executed by sqlsrv_query

I run the following code: $sql = "UPDATE [dbo].[NOTA_FISCAL] SET [STATUS] = ?, [USUARIO]= ?, DATA_TRATAMENTO = (getdate()), [MOTIVO_CANCELAMENTO] = ? WHERE [ID_NOTA_FISCAL] = ?"; $params = [...
asked by 19.01.2018 / 13:09