I have a table in PostGre whose Id field is of type Integer and primary key.
As records are being saved, numbering ranges from 1 to how much?
I'm used to the Dataflex database, where table records (by default) start from 1 and go up to 999999...
I am studying SQL Language and am having some problems in creating tables, I can not set a default value in a column, whenever I apply it indicates a syntax error. Can someone help me? I have no idea what is happening ... (If there are more erro...
I have a sales table and would like to select customer sales, but if the customer made more than one sale per month, I would like it to bring the older one just, how could I do that?
I do not have SQL code to provide because I do not know whe...
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
,...
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'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...
1 - My software in C # with SQLEXPRESS database LocalDB does not open on another PC, even installing all dependencies.
NOTE: In my PC Development works perfectly.
2 - Programs that I have already installed on the Client:
Microsoft SQL Server...
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....
Is there any way to know which tables have at least 1 trigger?
For example, I have a system with 10,000 tables, and I would like to know which one has a trigger.