I have an application made in VB.NET where I have customer registries.
Now I need to implement it as if it were a certain permission from the customers to third parties who can represent such customers.
And it needs to be done with voice perm...
I am performing a query on a Sql Server database, however the special characters are returned as follows:
MAR�O
instead of
MARÇO
I was able to fix using the utf8_encode() function, but I do not want to have to deal with each res...
I am making a people registration form which when I finish entering the data it shows a MessageBox saying with which ID the person was registered.
For this I use a% w of% of my query (I'm using Entity Framework model first), but fo...
I'm trying to make a login system between PHP and SQL Server and is giving the resource (7) of type (SQL Server Statement) error.
index.php
<form class="form-horizontal" id="FormLogin" action="login.php" method="post">
<div clas...
I'm having problems performing a select (using LINQ) in a View in SQL Server 2012.
The values stored in the database are as below:
ID_Acomp ID_Pessoa Nome Data
26 300 MONTEIRO 01-01-2016
27 300...
I'm getting the following error message when attempting to connect to the AZURE hosted bank through a WEB application:
An exception has been raiset that is likely due to transient failure. If you are connecting to Sql Azure database, consi...
I searched in many places and was amazed to find almost nothing of PHP OO using SQL Server. In short, I can not understand what is wrong here, I think it helps, thank you in advance.
<?php
class Conexao{
private $Localhost = 'NOTEBOOK...
I need to create a query that calculates the average of a vendor "score". Here is the query, and then the explanation of the fields:
SELECT distinct C7_FILIAL,
CASE WHEN C7_FILIAL = '0201' THEN '0201 - METAIS'
WHEN C7_FILIAL = '...
Inquiry:
SELECT
ROW_NUMBER() OVER(ORDER BY V.DATA ASC) AS ID,
V.CHAPA AS CHAPA,
F.NOME AS NOME,
V.DATA AS DATA,
CASE WHEN V.BATIDA IS NULL THEN 0 ELSE V.BATIDA END AS FOLGA
FROM
ARELBATIDATRANSITOVIEW...