Questions tagged as 'sql'

Tagged questions
1
answer

Problems with sql in access, incompatible data types

Test / error image: I just want to fetch the data between one date and another, using: SELECT * FROM tblTRAZA WHERE FECMOV >= '2013-01-03' AND FECMOV <= '2013-01-09'; But I already tried other date formats to query as yyyy/m...
asked by 02.06.2014 / 14:15
1
answer

RANDOM function in IBM Informix BD?

I need to use a random () function in SQL in an Informix database version 11.50. However in the select below it returns syntax error: select random(), codigo from minha_tabela; 674: Routine (random) can not be resolved. Error in line 1 Near...
asked by 29.03.2014 / 22:35
1
answer

Map Hibernate classes with composite-id and joined-subclass

How can I map a class with composite-id and extend another class? I'm using the example in: http://www.javacodegeeks.com/2012/08/hibernate-composite-ids-with.html I have tried to change the code, but when I try to insert data using this m...
asked by 28.03.2014 / 14:31
1
answer

How to use SQL min () with float?

I have the following database table: *Table structure for table 'resultados' */ DROP TABLE IF EXISTS 'resultados'; CREATE TABLE 'resultados' ( 'cpf' varchar(14) NOT NULL, 'nome' varchar(255) DEFAULT NULL, 'codcurso...
asked by 25.06.2014 / 10:03
1
answer

Sql Timeout with WebMatrix.Data.Database

Using the WebMatrix.Data.Database namespace, I'm having trouble executing a query that returns a lot of data, resulting in a Timeout. How can I increase the timeout of this query? Code sample: var db = WebMatrix.Data.Database.Open("Defau...
asked by 20.06.2014 / 19:50
3
answers

How do I create a view in mysql by taking data from 4 or more different tables?

HowcanIcreateaviewanddisplaythedataasfollows:     
asked by 21.06.2014 / 22:26
1
answer

What are the SQL formatting patterns? Do you have any tools that can do that?

I asked a similar question, but about javascript. But I read a lot of SQL and MySQL codes. Is there a commonly accepted pattern? Does anyone know of a tool that validates or modifies the code?     
asked by 25.03.2014 / 17:28
1
answer

Generating tables in sql-server with hibernate

I'm migrating a java system, to work with 2 or more databases. I created the tables for firebird using hibernate without many problems. The second bank did not succeed. The SQL Server. Why do microsoft products have to be different? Good ......
asked by 25.04.2014 / 18:21
0
answers

Integration Services does not insert insert with high quantities [closed]

I'm using Integration to load into an identical table in another database on the same instance, but the Integration package does not end the operation when I try to perform an insert with a high number of records (34,000) when the amount of reco...
asked by 02.01.2019 / 11:40
0
answers

jpgraph empty square php line chart [closed]

Here's my code to receive data form: if(empty($_POST["GESTOR"])) { $where_GESTOR = ""; } else { $GESTOR = implode( "','" , $_POST["GESTOR"]); $where_GESTOR = " and B.GESTOR in ('$GESTOR') "; } if(empty($_POST["FORNECEDOR"])) {...
asked by 02.01.2019 / 20:45