I made this query, which will compose a view.
SELECT DISTINCT
US.EMPLOYEESTATUS
,US.EMPLOYEEID
,US.EMPLOYEEFIRSTNAME + ' ' + US.EMPLOYEEMIDDLENAME + ' ' + US.EMPLOYEELASTNAME AS FULLNAME
,US.GRADE
,SO.SOLICITATIONID
,...
I made code in the declaration part of the real number that word balance that it will get a number with 6 digits and 2 two decimal places after the comma, but all the values that I enter are truncated, how to solve? >
create database uri
defaul...
SELECT CASE WHEN VALOR > 0 THEN
VALOR ELSE
"Não tem"
END AS NOMECOLUNA
FROM BLABLABLA
I'm having an error where it's not possible to convert "does not have" to int.
The issue is that I wanted it to return written that it does not have wh...
I have a foreach looping in a file's data, this loop generates some values that are entered in array with array_push , precise break those values entered in this array to generate multiple INSERT INTO because...
I'm learning how to use tables with PIVOT in Sql-Server. I have a table with the item name, the vendor name, and the customer id.
Item | Customer | ID Rep
Pen Set | 1001 | Richard
Binder | 25092 | Nick
Pen Set | 5149...
I'm having difficulty joining two tables and using some aggregate function, I've tried it like this:
SELECT nome FROM produto
INNER JOIN vendaproduto SUM(quantidade)
ON produto.idproduto = vendaproduto.idproduto
But it is giving error ......
My code displays a list of people and a search field at the top.
everything works fine, including searching.
but I need people to appear randomly. The problem is that when I use the ORDER BY rand () (or any other ORDER BY) my search stops workin...
Gentlemen, my numbers are coming out unformatted when I make the select directly in the bank, they are coming out as follows:
REALIZADO META
61274436,2090003 80000000,00
How can I make them readable for anyone to interpret?...
Hello, I am creating a data structure in SQLServer and I have the following situation:
I have a list of contact types (people, public, commercial, etc ...)
This list can be changed by the user, but it can only have 1 element as default....
These days, a guy told me: "Avoid forming SQLs by concatenating strings. Doing this is asking for security issues with SQL injection, and for that reason it's considered a bad programming practice." >
What about merge variables into a String t...