Questions tagged as 'sql'

Tagged questions
0
answers

Doubt with output format pgAdmin III

my question is this: There is some way that when generating a query in postgreSql the first row comes out with the following ================, as the following example shows: campo1 campo2 campo3 campo4 1 ===========================...
asked by 27.05.2016 / 05:52
1
answer

Error in XMLTYPE in xml with namespaces

The following sql statement is causing me an error LPX-00601: Invalid token in: '/ soap: Envelope / soap: Body / GetRatesTreeResponse'. Could you tell me if you see any failure? WITH mydata AS (SELECT TO_CLOB('<soap:Envelope xmlns:soap="...
asked by 10.05.2016 / 12:35
0
answers

Insert datagrid data view C # ASP.NET [closed]

I am creating a sales system, at the time a sale is registered I want the products that are in a datagridview with the ID of the sale inserted In my SALE class I have the following code: public string Insertar(Venta Venta, List<DetalleVe...
asked by 30.07.2016 / 04:46
2
answers

SELECT .. JOIN to relate 2 tables

Good evening, I have a problem because I currently have two tables in mysql and at the time of making the query I can not make them show me all their data because I do not know how to relate them. The primary keys are CedulaAlumno and CedulaRepr...
asked by 17.05.2016 / 02:05
0
answers

Fields that have no Access sql Access

I'm trying to get an sql for Access that takes out the records that have no relation, the key of the references is Type, Anne, Number and the other table, article, has the fields: type, anne, number, dossier I have done this but it does not retu...
asked by 16.05.2016 / 13:15
2
answers

How to get all the records of a table with maximum date?

I have two tables of which I have repeated values and what I want to obtain is the all value with maximum date of each table and that they do not repeat themselves and I do not know how to perform. I have two tables one of them is A which has...
asked by 06.11.2018 / 16:02
1
answer

insert exec opendatasource error 7391

Good morning, I run this code in a database sql server 2008 R2, domain DBDS1 to another database sql server 2012 domain coms1 and it throws me a table with the data correctly. EXEC OPENDATASOURCE ('SQLOLEDB','Password=6tgfjsoeuW.;Persist Se...
asked by 04.09.2018 / 19:02
2
answers

Update sql with join

I am trying to make update where I would need to join to join two tables. I have the table ADJUDICACION and the table PROVEEDOR , in which the join would be: ADJUDICACION.ID_PROVEEDOR = PROVEEDOR.ID . And what I wa...
asked by 08.08.2018 / 14:04
1
answer

Error when saving data in Cake - SQLSTATE [23000]: Integrity constraint violation

I have 2 tables, roles and operations and are related in a third table operations_roles . This is my migration file: $table = $this->table('roles'); $table ->addColumn('user_id','integer')->addForeignKey('u...
asked by 16.09.2016 / 04:25
1
answer

Select table in PHP by variable

I have my web connected to a database, and I select a table by putting it as it is called, but now I have divided by sections, and capable, what I want to show is in another table, and I want to change it directly from a variable: I give the exa...
asked by 12.12.2018 / 00:05