Questions tagged as 'sql-server'

Tagged questions
1
answer

Entity Framework creation of bank

I'm new to entity and I'm following a step-by-step guide to creating a Code First ( link ) . I created the application, debugged it and it runs perfectly without any errors, however no bank is created ... The main code follows the App.config...
asked by 19.01.2018 / 01:01
0
answers

Compare values of two tables in a Procedure

I have an application that lists in a grid files that are registered in the table    SCF_Process Documentation However, now I need to list only if this file also exists in the table    SCF_ARQUIVO_UPLOAD What the application does i...
asked by 24.01.2018 / 19:29
0
answers

I changed the SA password and Visual Studio can not map Bank objects

I have changed the password of my SA SQL Server user by Management Studio. I tested it in Management and everything went well, I created a 'Test' database with a table called 'Testing' and I went to test with Visual Studio     Home I created a W...
asked by 21.01.2018 / 20:07
0
answers

C # Windows Forms - Integrated Database

I will develop a Desktop application, and this application will access Local Database, my question is: If I make an application that accesses SQL Server normally, when I generate the release version, will I have to install SQL Server on my cl...
asked by 15.01.2018 / 17:27
1
answer

SQL Server Connection on laravel

Well, I have the following error: tcp provider: no connection can be made because the target machine has actively refused them. I'm using a bank created on my own machine, it's with the ODBC drivers, firewall disabled, however I use wamp to r...
asked by 11.01.2018 / 16:52
1
answer

Web application to access the local base in different networks

I'm developing an asp.net web application to import data from an old (desktop) system to a new (web) system. I want to make a tool to import the data from the clients to the new system, ie the web application have access to the local database of...
asked by 09.01.2018 / 15:11
0
answers

CPU usage without an explanation

In our database we use to report the Performance Dashboard Reports, and we are receiving this type of peak .. What bothers us is the orange bar issue. Does anyone know how we can do to find out what is raising the CPU so much?     
asked by 09.01.2018 / 19:05
1
answer

Grouping and adding in a query in SQL Server

Good afternoon, I have the following problem: I'm developing a C # program to query internal company data. It's working perfectly, but I need to group field (s) and add other value (s). Query(C#+MSSQL):SqlCommandmyCommand=newSqlCommand...
asked by 04.01.2018 / 13:27
1
answer

SQLQuery - Some Duplicate Records

Galera, in the query below is bringing as follows. UsuID Consultor Tentativa 1 Abertos 95093 Gabriela 96 However, it is meant to bring the following: UsuID Consultor Tentativa 2 Abertos 95093 Gabriela 48...
asked by 08.01.2018 / 18:27
0
answers

Doubts PHP + Sql server

Good Afternoon Staff I'm new here in the forum so I do not know if I opened this topic in the right place. I need a help on a table that I'm generating with php through some queries being one in mysql, and from the result of it I perform a...
asked by 03.01.2018 / 17:49