Questions tagged as 'sql'

Tagged questions
3
answers

Implementation of generic CRUD

I have the following class CRUD which is generic: public abstract class CRUD { protected string tabela = null; protected object classe = null; public CRUD() {} public virtual void insert() { //código } public virtu...
asked by 02.01.2015 / 19:41
1
answer

What is the meaning of the "equal or removed indexing" error in MySQL?

I'm working with small relationships and I noticed that in a state table where I've related the id field to the país[id] table I get this error or alert message, I'm not sure. Already in a relationship of table cidade to...
asked by 19.10.2014 / 15:54
2
answers

How to mount a Transaction with Commit and Rollback in Oracle?

I'm trying to set up a transaction in Oracle, but I do not know how to do a Rollback if there is an error in one of the querys. I searched some sites, but I did not find anything clear and simple that explained. I started doing this: DELETE...
asked by 20.03.2014 / 18:14
2
answers

Union problem in mysql

I am trying to perform a query and is giving the following error:    Unknown column 'FILIAL' in 'field list' The query is as follows: SELECT TICKET, DATAHORA, TIPO, ESTADO, CRITICIDADE, LOGIN, PARECER, INFOPEND, PROP, DATAPROP, PREV, SR...
asked by 17.07.2018 / 14:49
3
answers

Reverse ordering SQL [closed]

Is it possible to sort the codes of a select inverted? Example: As the last number of the first element is smaller it comes first and for tie criterion the second decade will be checked, as well as in the normal ordering, but as informed,...
asked by 15.05.2018 / 18:57
2
answers

Is an application possible on different computers running CRUD simultaneously?

I am creating an application in C # using the VisualStudio 2015 enterprise next to SQL Server 2016 to save the data, but I am almost finishing the project and still do not know if it will really work! p> I need to install this application on...
asked by 10.11.2016 / 17:44
2
answers

Multiple MySQL Assignment [closed]

How to assign multiple values to an attribute of a table in MySQL? For example a table where a client can have several phones, and in assignment can be passed the several customer phones at one time.     
asked by 30.05.2016 / 21:17
3
answers

How to route rows to columns?

Already answered by Motta, thanks for your patience. How can I transpose rows to columns in SQLServer, so that something like this: Keepthisformat?     
asked by 29.07.2016 / 22:26
2
answers

View with double SELECT from the same table

I need to mount a VIEW with three fields, but one depends on the other to be calculated (two of them are from the same table in different lines I need to "link" them), how do I add those fields in one place? The select's are as follows: SELECT...
asked by 23.04.2018 / 18:08
2
answers

Error trying to DELETE with INNER JOIN in MYSQL

DELETE FROM 'tb_users' INNER JOIN 'tb_marker' ON tb_users.id_users' = 'tb_marker.id_users' WHERE 'tb_users.id_users' = 12 Here is the error:    You have an error in your SQL syntax; 'INNER JOIN' tb_marker 'on' tb_users.id_users' = 'tb_m...
asked by 19.04.2017 / 21:47