Good afternoon, guys.
I gave the following command in MySQL:
UPDATE procedimentos SET valor = '2.400.00' WHERE procedimentos.id_proced = 1
The value field is a double , I already tried with float and gave the same error, what exactly wou...
I have the following code block:
sqlConn.Open();
SqlCommand inserirAluno = new SqlCommand("INSERT INTO ALUNOS (Nome, DataNascimento, CPF, Endereco, Bairro, " +
"CEP, Cidade, IdEstado, Sexo) OUTPUT INSERTED.ID" +...
I have this querry that gives me the total nr of rows that start with the same code
USE CCILCDatabase;
GO
DECLARE @mes int;
SET @mes = 1;
WHILE (select @mes) <= 12
BEGIN
SELECT LEFT(CONVERT(VARCHAR(10),[CPVCodeID]),2), COUNT...
I'm servicing a database, and I have the following situation;
in the database I have 5 columns in a table, they are:
ID (PK) | IDBillet | Result | Borrowed | Date |
I have to filter for the user to see, only the IDBilhete that is missi...
Good morning!
I need to insert the return data of a Select into a .txt file containing the column names and separating the data with ";"
How can I do this?
Thank you in advance
I'm creating two foreign key references pointing to two different tables, but I'm getting an error creating one.
There are no primary or candidate keys in the referenced table
'dbo.TB_PODERES' that match the referencing column list in th...
I have a estoque table where records of all supplies are stored, with the stock-in date , the supply code , and unit value of the part, my need would be to get the highest unit value of the most recent date of each supply:
Data...
Galera, in the query below, is as follows.
Ano Mes Horas total_horas
2018 1 107 766 H
2018 1 225 766 H
So, I want you to bring in another column the division of the column "Hours" by the column "total_horas", bringing this...