Questions tagged as 'sql-server'

1
answer

Working with Entity Framework, Multithreading and SQL Server in C #

I'm using Entity Framework and Multithreading in a C# project and I'm experiencing connection problems with SQL Server . Well, I wanted to improve the speed of data searches for a grid because they are very time-consuming...
asked by 13.10.2014 / 21:14
2
answers

RAD Studio XE6 does not connect to any database!

Program used: RAD Studio XE6 (32bits). Problem: When creating a new Desktop or Mobile project, when trying to configure the connection to any database, either by FireDAC or dbExpress, the following error occurs: "DBX Error: Driver could no...
asked by 15.08.2014 / 16:10
2
answers

SQL SERVER Integration and Active Directory

Hello, I would like to know if it is possible to have Active Directory authentication pointing to a database in SQL Server, where I have user and passwords. The issue is that I have a user base and that all systems authenticate to it, I would lik...
asked by 16.05.2014 / 21:15
1
answer

Call Function or Procedure Several Times

How to create a Function or Procedure that calls another Procedure to perform a neighborhood change in my ERP system? Follow the procedure below I want to set values for the parameters of it. It should be called based on a neighborhood table...
asked by 09.04.2014 / 22:05
1
answer

Batch calling "dtsx" does not connect to Avaya CMS

I created a service in dtsx that needs to connect to CMS Avaya . It turns out that when I squeeze it through Visual Studio it follows the process to the end normally. But when I call a batch it does not allow authentica...
asked by 04.04.2014 / 16:18
2
answers

Foreign key error while deleting a record

I have a table with products and another with the category of that product. In the category table I have a detailsView with a delete button, and it deletes when a category is not associated with a product (from another table), that is when a cat...
asked by 17.07.2014 / 13:20
0
answers

Blank comparative filter in Power Bi

Hello, I created two filters to make a comparison by duplicating the facts with the records for the measurements and the tables that make the filter with the proper relationships. However, for some reason, when filtering through a specific filte...
asked by 20.12.2018 / 13:36
2
answers

Doubt with a query (SQL Server)

Good afternoon! I have a set of information in a SQL Server database (I'm still learning SQL Server), and I need to filter the information that is returned to me. They are information of employees of a company (enrollment, cpf, name, position...
asked by 21.12.2018 / 18:18
1
answer

Making temporary table comparison

Good morning, I have questions on how to perform a comparison between a temporary table and a database table. What I want to return is, among all the data in the temporary table, it returns the ones I have in the database (null) and the ones I d...
asked by 14.12.2018 / 13:47
0
answers

SQL Server Extension not found

I'm trying to create a connection to SQLServer through PHP 7.2 NTS, and even trying all possible combinations of DDL's I'm not even able to upload the embedded server. My setup is as follows: ->Win10 x64 / PHP 7.2.13; ->Configuração d...
asked by 24.12.2018 / 13:17