I need to perform a query in SQL Server 2017, where I need to bring the following information: Codigo do chamado , Data Abertura , Interação , Analista , UltimaInteração (would be the last interaction date) and...
I have an application in Flask and I'm using SQLAlchemy to get access to SQL Server.
I would like the connection to the database to be made by a generic user and the password is a "token", I thought it would only replace the parameters but no...
I have the tables (and their relationships) in the diagram below:
I need to do the following:
Bring all the fields of the TBCADCRE table and an extra column named ADQ with all the TIPADQ that the user has (can have a maximum of 6) separate...
I have tables in my database: Orcamento , Maquinas , Veiculos and Acessorios .
I need to record the costs of each of them, for example to each table will be recorded a cost daily
I create a table called Custo...
Error while trying to connect Android / Java with SQLServer
Here is the error:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Socket closed". ClientConnectionId:585...
I need to insert a calculation column in this view below, but the message
Msg 205, Level 16, State 1, Procedure ConsolidatedStudyBaseSifix, Line
4 [Batch Start Line 9] All queries combined using a UNION, INTERSECT
or EXCEPT operator mu...
Good evening guys,
I have a .mdf database in a Windows Forms and I want to make the connection string it, can anyone help me?
My version of Visual Studio is 2015 and the file is in:
C: Documents \ Visual Studio 2017 \ Projects \ Projects \ Final...
I'm using SQLSERVER
Condition (What the result should return me)
· Creation of the agenda. It is necessary to create the flow for creation of agenda and blocking to reserve the vacancies;
When crossing data from two tables I need to alloca...
When executing the query I get a TimeOut Sql Server error:
Connection Method:
public SqlDataReader GetDataReader(string comando)
{
SqlConnection conn = criaConexao();
// Cria Comando
SqlCommand...