Questions tagged as 'sql'

Tagged questions
3
answers

How to use the alter table by modifying an attribute for PK and FK?

I have a table Funcionário , where its PK is this Cod_Func . Then I created this table Vendedor , I created the attributes manually, I did not put Cod_Func of Table Vendedor as PK , because this is...
asked by 25.11.2017 / 17:07
1
answer

How to create a query with a nonexistent table and no error

I have a query that runs on several different schemas in the database, and there is a table that specifies that some schemas have, and if the value exists, it returns. SELECT t.coluna1 ,t.coluna2 ,(SELECT coluna3 FROM tabe...
asked by 09.11.2017 / 20:31
1
answer

Are there classification metrics for preparing SQL queries?

Doubt Is there any method for sorting in difficulty levels, an SQL query in easy, medium, or difficult ? This question may be a bit subjective, but speculating may be a good option. Context I was responding to some SQL issues on the h...
asked by 21.11.2017 / 21:10
1
answer

nodes extraction via postgreSQL

It is possible via commands in Postgres to treat vector data. I have a table with data that represent the displacement of objects and I need to extract final and initial vertex. Is this possible via PostgreSQL?     
asked by 25.04.2018 / 20:16
1
answer

Error inserting data from an excel file into sql

I have a problem when I insert data from the excel file into the database because in a field I am inserting it says that it is not of type time and does not let insert, but in the Excel file the text is written is only hours or is time...
asked by 02.11.2017 / 17:35
1
answer

Is a "Group by" possible for column content?

I was wondering if it was possible to use GROUP BY based on the date of a column, in this case the ANALYSIS column that creates groups whenever it finds 0, instead of the column. DIA MES YEAR TODAY TOMORROW ANALY...
asked by 25.10.2017 / 00:30
0
answers

What is the best architecture? Mysql multi BD or single?

We are currently working with web software that is going to market with great acceptance. It receives many partner interfaces and generates a lot of content for each table. In the past we chose to create a database for each client, and a central...
asked by 25.10.2017 / 20:50
1
answer

Linq command to bring a decimal query C #

I'm having trouble understanding how to bring a query from the textbox of a column where the field is decimal? if (txtNomePesquisar.Text.Equals("")) { MessageBox.Show("O que você procura? "); } else { var clientes = cc...
asked by 26.10.2017 / 00:59
0
answers

Access database getting heavy after running query via VBA

Next, I have a Access database with a table named tblDados . This table contains 19 initial fields. I import a CSV file que contains 1 million records, so far, save and close the uncompressed and repaired database , it...
asked by 25.05.2018 / 19:40
1
answer

Update on a column using more than one return

I have to update a given field of a table by subtracting from it the values returned from a select in another table. The problem I am facing is that as select returns more than one value and I have to go subtracting value by value, so I can comp...
asked by 14.11.2017 / 00:05