I would like to display an alert message to the user without causing an exception in the procedure. I am using SQL Server. So I can not use RAISERROR , nor PRINT , as it is not shown to the user.
Is there a way to display an alert...
I need to list every month within a period, including the ones that did not move, for example:
My Query:
SELECT LEFT(B8.B8_DTVALID, 06) AS VALIDADE,
SUM(B8.B8_SALDO) AS VENCIDO,
0 AS VENCENDO,
0 AS AVENCER
FROM SB8030...
I want in a "Test" column to set the "S" value to only the first line of a given "code" and all others set the value "N" and so on to all other codes in a SELECT, I'm using SQL SERVER.
ID COD VLR DATA TESTE
01 123 100 "06/09/2015"...
What field should I use in SQL Server to save a running time? Example: 2Days 23H 47Min 00Sec.
If you have an example with Fluent API it will help a lot.
I need help solving an incompatibility problem.
The company I'm working on is migrating from a SQL Server 2008 to 2012 Bank, but we've identified some issues.
The main one is the declaration of (NOLOCK) without WITH in VIEWs, FU...
I have an Asp.Net MVC project with Entity Framework 4 and SQL Server, where there is a Action that receives via POST a csv file.
Considering memory usage, processing time and resources, or any questions about the database...
I'm using the following code:
try {
$con = new PDO("sqlsrv:Server=172.20.21.193,9090;Database=sgt","deb","123123");
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die ("Erro na co...
Good people I'm doing a job in using C # and my knowledge is still very limited and I'm having a question.
I have 2 tables and what I wanted to do was to show the 2 information where the information would not be repeated.
Thisisa1-nrelationwh...
I am developing a registry system in VB and need help writing the CheckBox information to the SQL Server database.
The column is in bit in the database, I do not know how to pass the parameter so that the user's choice is saved...
Based on the code below, where can I retrieve results from ADODB.Command ?
This unit will always work with stored procedure , and the parameter types that will be used are input and output .
unit uadolibrary;
interface...