Questions tagged as 'sql'

Tagged questions
1
answer

Configuration many to many code fast migration

Good afternoon! I have this many-to-many configuration in my project. public class Usuario { public Usuario() { this.LocalTrabalho = new HashSet<LocalAtendimento>(); } public virtual ICollection<LocalAtendim...
asked by 30.09.2017 / 17:37
1
answer

Doubt - Insert table SQL Server 2012

I need to insert some information in the table called task, however, only when a certain condition is accepted that in the case are these two date fields, I put it to today for example if it were manual, that is, it would insert into the system...
asked by 05.10.2017 / 14:25
0
answers

Opening SQLite3 on Windows10

When I open SQLite3 in Windows 10, it simply opens the command prompt, giving the command permission in front of the sqlite > line line. Already in windows 7 and 8 it opens normally. My intention of using SQLite is for a simple connec...
asked by 31.03.2017 / 17:40
2
answers

Take tab (tab) of varchar

Good afternoon everyone! I'm trying anyway, but I can not seem to get a tab at the end of a varchar in firebird. Does anyone know how to do it? Thanks in advance. Editing to stay more specific: Ex: select guia, convenio, nome, tri...
asked by 09.02.2017 / 19:35
2
answers

How to calculate total accumulated of 365 days joining two different years?

I'm trying to check the cumulative total for a certain amount, which starts in September of a year and runs through August of the following year, and then resumes. I'm doing this with a long historical series, so it would be n sums for various d...
asked by 15.02.2017 / 13:00
0
answers

PHP - problems with code to reset password

I am trying to create a link that is sent to the user so that I can reset the password: I have the following code that sends the code to the user: <?php include("config.php"); if(isset($_POST['submit_email']) && $_POST['email'])...
asked by 16.05.2017 / 22:56
0
answers

Engine with less RAM than InnoDB / XtraDB in MariaDB?

InnoDB allows you to make multiple INSERT and also UPDATE without creating LOCKING , while in MyISAM it is not possible to make multiple INSERTs at the same time and to make matters worse MyISAM does not support TRANSACTIO...
asked by 13.01.2017 / 22:31
0
answers

Loading JTable and processor gets high process [closed]

I am making a system and it has a JTable and I need to load my data, I was analyzing through the task manager that when this function load the table is called, it increases the processor load a lot. What can it be? I already tested it and...
asked by 11.01.2017 / 23:25
1
answer

Insert Error with FK

I have two tables, Client and Plan, which have the 1:1 relationship. I have 3 plans registered in the bank with their respective data. But when trying to insert a Client that has a Foreing Key that is referring to Id of the...
asked by 21.12.2016 / 21:23
1
answer

Select Query with AJAX and PHP

I'm developing a system in php and I own a page where it lists multiple results of a SELECT , so far so good ... and I have input text where I would like every letter I typed in it, the results would be filtered according to the let...
asked by 10.09.2016 / 22:38