Is it possible to search for certain values in columns of other tables?
Example:
I have a number: 23028908
I want to search my bank for all columns that have this value.
Is this possible? How can it be done?
I'm trying to make paging with SQLServer 2008 as follows:
WITH CTEResults AS
(
SELECT DISTINCT
SolicitacaoServico.AutoId AS Id_Solicitacao,
Pessoa.Nome AS Nome,
Beneficiario.Codigo A...
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 have a problem where I can not add anything to the table and the error always appears:
sqlite3.InterfaceError: Error binding parameter 0 - probably
unsupported type.
The code I'm trying to add values to and this:
p_name=input("...
Well, good afternoon.
I have the following question.
I have a questionnaire with 10 questions, the answers to these questions can be from 0 to 5, I would like to make a while leaving counting the answers.
I thought of the following way and...
In a table containing the CPF column I would like to format it to display the content appropriately. By proper means I mean the format 999.999.999-99 . Is it possible to format this content using regular expression?
SQLFiddle for testing...
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 have a select that returns some data from the database, but I need this select to return values only when in a group of values, there is x
SELECT pessoas.id AS ID,
pessoas.nom_pessoa AS nome,
pessoas.cod_sexo_pes AS sexo,
YEAR(FROM_DAYS(TO_D...
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"...