Posts by Gustavo Castilho • 392 points
17 posts
-
0
votes0
answers44
viewsQ: Calculate time intervals in months ( Date List )
I have a Date List 01.01.2017 13-month interval 02.02.2018 period of 14 months 03.04.2019 interval of 8 months 19.12.2019 Is there any way to make a select that returns months between listed dates I…
-
2
votes0
answers81
viewsQ: Calculation of Due Dates Based on Number of Plots Chosen
In a function I want to put the parameters that would: Number of Plots and Total Value My problem would be how to generate maturity dates of installments in Postgresql how to work with the dates to…
-
0
votes1
answer150
viewsQ: Which Postgres SCRIPT to list all Schemas?
Do I need to know which script I use to list all the Schemas of a Database ? 1 Condition is to list all Schemas I created and do not need Postgres Schemas I need this information to be able to…
-
1
votes1
answer150
viewsA: Which Postgres SCRIPT to list all Schemas?
This simple command will return to Voce the schemas that Voce created in the database plus the public schema select schema_name from information_schema.schemata where schema_name !~ '^pg_' AND…
-
-1
votes1
answer77
viewsQ: Which SQL Script in Postgres to return the fields belonging to PK?
Which SQL Script in Postgres to return the fields belonging to the primary key of a specific database table ?
-
1
votes1
answer77
viewsA: Which SQL Script in Postgres to return the fields belonging to PK?
In my researches I found several ways to make this script, I want to show here a very simple way to return this data, this to help people who are starting select kcu.table_schema, kcu.table_name,…
-
1
votes1
answer65
viewsQ: What SQL Script in Postgres to return the Functions of a Schema?
What SQL Script in Postgres to return the Functions of a Schema with its input parameters ?
-
3
votes1
answer65
viewsA: What SQL Script in Postgres to return the Functions of a Schema?
SELECT inf.routine_name, par.data_type, par.ordinal_position, par.parameter_name, par.parameter_mode FROM information_schema.routines inf LEFT OUTER JOIN information_schema.parameters par ON…
-
1
votes0
answers42
viewsQ: Doubts of Alignment between two Tables
I have a little doubt about the alignment between these two tables <table id="tableCabecVendasML"> and <table id="tableDadosVendasML"> NOTE: I made this page this way because I want to…
css3asked Gustavo Castilho 392 -
5
votes2
answers1818
viewsQ: How to adjust a DIV inside another DIV vertically?
I’m having the following problem with CSS.. I sent you an example of what I’m trying to do Example of the Code, click here I would like the <div id="divAreaMenuLateral"> that this in orange…
-
0
votes0
answers91
viewsQ: Installation MSSQL 2014 express or MSSQL 2016 PREVIEW
I have the following problem.. I installed MSSQL 2016 Preview on a server that I can only access via Terminal Service Windows Authentication - Administrator The problem is that everything I find to…
sql-serverasked Gustavo Castilho 392 -
3
votes2
answers1273
viewsA: How to bring in the SELECT result the conditions entered as parameters?
If I understood right is just put the parameters as Fields: SELECT a.*, cast(:dataIni as date) AS inidate , cast(:dataFin as date) AS inidate, :dataIni as DataInicial, :dataFin as DataFinal FROM…
-
-1
votes4
answers1944
viewsA: Run query that concatenates parameters (@p) in Firebird
for you to test this in IBEXPERT or even use inside your application Voce has to do a query of a Soted Procedure Voce has to pass to a STORED PROCEDURE Your Select Origin Command of a precedent…
-
1
votes1
answer1714
viewsQ: Error 5: Access denied in an attempt to install a service created on Windows Server 2012
I created an application of services and after the installation of it, I can not start it appears the following message: I’ve checked application permissions; I tried to delete "logs"; I’ve…
-
2
votes2
answers2135
viewsQ: Problems installing a service on Windows Server
I developed an application in Windows Service, in Visual Studio; I cannot install the service on Windows Server; I made a suggested change and also not registering, occurring the following problem:…
c#asked Gustavo Castilho 392 -
0
votes3
answers462
viewsA: JSON serialization and deserialization in desktop application
Solved Problem in Two Ways public class RootObject { public List<List<Result>> result { get; set; } } public class Result { public string CodigoReduzido { get; set; } public int Estoque…
-
3
votes3
answers462
viewsQ: JSON serialization and deserialization in desktop application
{"result":[[{"code reduced":"019076-3","Stock":200,"Price":900.77,"Price":225.19,"Description":" ASUS AMD RADEON R5 VIDEO CARD 230 1GB DDR3 64BITS R5230-SL-1GD3-L *IMP","Group":"VIDEO…