Questions tagged as 'sql'

Tagged questions
1
answer

Receive value Date in a modal and field date

I continue with the editions of registers on manners. Well, I find that when I pass the data to the modal I receive everything but the date that I do not get marked the BD. Vereis I keep sending the data as always: Adding the command id t...
asked by 31.08.2018 / 07:19
1
answer

Tags in Crystal Reports

In my next query I try to show some tags designed in crystal reports . How would you do that according to the AMOUNT of existence that a record has, that is to say if in Quantity = 2, two labels are generated? This code is in the cry...
asked by 16.02.2016 / 05:50
0
answers

"Intercept" incoming SMS from Android Studio app, Android 6.0 [closed]

I would like to know how I can intercept an SMS in Android 6.0 from my app, since it is a tracker service and receives the maps link from an SMS that we previously sent "Where" to the tracker and he responds, I am interested in giving it to the...
asked by 30.05.2017 / 15:19
1
answer

Error creating procedure in SQL

I am creating a simple procedure, in SQL, simply its operation is based on returning the data of those incidents that are in situation = 2 and have not reached the situation = 3, together with the name of the reporting user and the type of user....
asked by 04.12.2016 / 12:18
1
answer

Help with a JOINS in 2 tables in MySQLi in PHP

I commented to them I have read several times the blog of link but I can not implement a JOINS in my project, what I have so far works perfectly but I'm doing 2 or 3 queries and the idea is to optimize the queries to my database for logical...
asked by 12.10.2018 / 18:24
0
answers

Automatically extract related data from several tables

I have had to face this problem recently and fixing it manually is tedious and avoiding errors by omission is not easy: Scenario: Preconditions: I have a WORK table with a numeric station that auto-increments. It is the master table...
asked by 16.10.2018 / 09:59
1
answer

HIVE - Error: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement

Very good. The first thing I have to say is that I am a first-time user of Hive, so my mistake may be a beginner's mistake. My problem is this: This is trying to create a table with five columns (game-clock, time, game-event, shot-clock, loca...
asked by 08.03.2017 / 17:23
2
answers

Increase RAM memory timerTask

I am doing a query to a table in the SQL database, the problem is, I have to consult the data in real time, therefore I have created a task every 1 second, but it turns out that the RAM memory increases until that is full. public void sent...
asked by 13.10.2016 / 23:23
3
answers

how to insert last 5 characters of a string?

Hello, what happens is that I have a system in asp.net and c # in which the user must enter 15 numbers in a textbox, but only the last 5 of them must be saved in a database field. Nose if there is any SQL function to do that, or pass the last di...
asked by 05.05.2018 / 19:32
7
answers

Get only month and day using SELECT in SQL server

Use SQL server 2008 R2 I want to make a simple select that using a GETDATE() show a specific date format without year:    day / month This select gives me the values but in separate columns SELECT MONTH(GETDATE()...
asked by 26.10.2016 / 16:23