Problem
When searching for texts containing apostrophes, no results are found.
Execution
DECLARE @cidade NVARCHAR(50)
SELECT @cidade = cidade FROM tabela_A WHERE id = xv
SELECT campo FROM tabela_B WHERE cidade = @cidade
The abo...
I'm creating an application with ASP.NET MVC5 , DAPPER , C# E SQL SERVER .
The problem is that in the data listing, you are bringing the empty fields, except the ID field, which comes to zero (0).
If anyone kno...
I am putting together a query that will need to get the term typed in a search and query for similarity in the content. A "rank" that is generated using these commands is being used.
The two commands seemed to me very similar, I could not mak...
In a query I am collecting data on representatives, customers and vendors.
Some representatives have salespeople, who in turn have customers. These cases are exceptional because the clients are linked directly to their representatives....
In tabela_A I have a cod_canal field where it is a INT , in tabela_B I have a canais field of type string and it separates the codes by , .
Example: 1,3,6,9,12 .
On a first try, I just thought abo...
I have a query with N relationships, in one of those related tables I need to select a specific column that follows the mes_valor pattern, where mes is an abbreviation for one of the twelve possible jan_valor , fev_...
SELECT HASHBYTES('MD5','123')
This select above returns me the following result: 0x202CB962AC59075B964B07152D234B70
But when I do an update to the table using the same hashbytes
UPDATE USUARIOSLOGADOS SET TOKENSESSAO = HASHBYTES('...
BEGIN
<<LOOP_EXTERNO>>
FOR V_EXTERNO IN 1..20 LOOP
DBMS_OUTPUT.PUT_LINE('Contador externo: ' || V_EXTERNO);
<<LOOP_INTERNO>>
FOR V_INTERNO IN 1..5 LOOP
DBMS_OUTPUT.PUT_LINE('Contador interno: ' || V_INTERNO);...
I have a procedure that runs a bkp from my database.
If I run it through SqlServer the bkp is performed normally
But when I call a trigger, another procedure or application bkp is not performed,
the folder is created on the server, but the bkp f...
Hello, I have the BDMCOM1 bank that has a Product Balance table and a Quantity column with values like this: 1,000. However I have another bank BDMCOM1_V3_ALEA that also has the Product Balance table and Quantity column, but with values in this...