I'm having trouble connecting the SQL Azure database through a web application published at this address:
link
This is the connection string:
<add name="Entities" connectionString="metadata=res://*/Context.ControleHorasContext.csdl|...
Error appearing:
An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: Error converting data type varchar to int.
public stati...
I want to use the full-text index in my SQL Server 2014.
I've created a catalog with the command:
CREATE FULLTEXT CATALOG [noticiasFullText] WITH ACCENT_SENSITIVITY = OFF
And when I was creating the full-text index in my table with the c...
I ran the command ALTER DATABASE [Banco] SET ENABLE_BROKER; but it has been running for more than 20 minutes and counting. Would you have a faster way to do it?
I am sending a request within a procedure by SQL Server using WinHTTP.WinHTTPRequest.5.1, the problem is that the request is taking too long and this is giving a timeout error. I would like to increase the SQL Server timeout time.
I'm doing t...
<?php
abstract class database {
/* Método construtor do banco de dados */
private function __construct() {
}
/* Evita que a classe seja clonada */
private function __clone() {
}
/* Método que destroi...
I'm trying to make a query using like in PHP and when I use one more than one word.
Only works if I only put one word.
In SQL Server the query works without errors .
<?php
function listaMatHistOS($conn, $equipamento){
$HistM...
Good afternoon everyone. I have a giant need to get things done.
I have an object DataTable with the result with column "ID_CLIENTE" .
I have an object Cliente with the property ID_CLIENTE .
Is there any way to...
I have a date in a patient table in the Sql Server database in the following format:
datetime (01/01/2016 12:50:00.000)
I want to check if the patient's appointment time has arrived.
For example: The time of the appointment is at 13:00...
I have the following SELECT in SQL Server:
SELECT
th.CidadeCod,
th.ContratoCod,
CONVERT(DECIMAL(5,2), ( SUM(th.PlacasLidas)/SUM(th.Trafego) ) * 100) AS [IndiceOCR]
FROM
controle.TrafegoFaixaHora th
INNER JOIN ssis.Co...