I have a .Net C # application that takes data via Web Service and saves it to a SQL Server 2012 database. The initial performance is 20 records per second. After having a 10000 records in the table, the performance begins to fall, gradually, rea...
Assuming that Oracle is known to have the capabilities of the sequence table.
I would like to understand why I recently implemented autoincrement in Oracle, since it was an existing feature in competitors (SQL Server, MySQL). What motivat...
I have a launch line, in which this line would need to receive the value of the previous line +1, some example of how to do this?
Table structure:
CREATE TABLE 'lancamento' (
'data' VARCHAR(10) NOT NULL,
'descricao' VARCHAR(30) NOT NULL,...
Good morning I need to bring only one product per branch, however in my table I have several times the same product just changing the date, I would like to get the product from the last date.
What I have:
SELECT ID, CODFIL, DT, COLUNAVARI...
I wonder if it is possible, after converting the date and bringing only the time, manipulate this result to return the closed time. The example below details it best.
CONVERT(VARCHAR(19), DATEADD(second, cr.open_date ,'1969-12-31 21:00:00'), 1...
I need to value the inventory of the company in which I work and for this I will get the last value of the items. I was using MAX , but I realized that if I did this, it would return me the highest price and not the last one registered in...
Hello, I would like to do the following calculated.
Initial date = September 11, 2017 at 11:35
Final Date = September 11, 2017 at 12:35 p.m.
It should appear to me 01:10.
Another example:
Initial date = September 11, 2017 at 11:35...
Does anyone know what a query would look like for a given employee's salary on a given date?
The salary readjustment history table for each employee has the following fields:
MATRICULADATASALARIO_ANTERIORREAJUSTENOMEADMISSAO_DATASALARIO_F...