Best answeres tagged with sql

1

answer

Doubts about class usage

Well, guys, good morning. How are you? I am writing a windowsform application, and in some situations I need to do multiple queries, insert and delete .. well, then I created a query class, a delete class and an insert class, where all my queries...

asked by 19.07.2016 / 12:29

1

answer

Display text field in dbgrid Delphi

I have DBGRID , and I need to show a field of type text , but when it shows, it appears (MEMO) instead of the text that was meant to be How do I make it appear? Note: I can not change the database field from text to varchar...

asked by 12.09.2016 / 19:24

1

answer

Problem when using LIKE of Sql in AngularJS

I've been having trouble searching for my app using AngularJS for a few days now, and I've been able to find out why: In query SQL with LIKE , it just is not getting the parameter as it should. > My function looks like this...

asked by 25.08.2016 / 17:36

2

answers

Limit 1 row in queries with primary key queries

One of the best practices for optimizing MySQL queries, dictated by an internet source, says that it is important to limit queries that already display only one row to one. For example, if I'm going to change a user's record, my current query...

asked by 26.08.2016 / 00:17

1

answer

Get the database time sql server formatted

My database has a difference of 4 hours, support so far has not given a solution, so I would like to know how I can format the time out: select CAST(HORA_FECHAMENTO AS datetime) as HORA_FECHAMENTO, CONVERT(VARCHAR(05), DATEADD(hour, +4, getda...

asked by 14.07.2016 / 16:34

2

answers

Inserting data in PHP

Good morning! I need a help Person I am facing the following problem I have two tables in the (clinics) and (users) I want to insert the data in the two tables in a way that is user- that the form is sent, the form data I've already m...

asked by 12.07.2016 / 15:11

2

answers

Perform an overall sum with all fields

asked by 10.11.2016 / 12:47

1

answer

Is it possible to leave connectionString dynamically?

I have read something and know that it is possible to leave a connectionString dynamically in an ASP.NET MVC application. But is it possible to create n connections where each authenticated user on the system has its own connection to a part...

asked by 12.08.2016 / 15:57

2

answers

Error 1093 in MySQL

Follow my code in MySQL: create schema if not exists Faculdade; use faculdade; create table if not exists Alunos ( RA integer UNSIGNED not null, senha varchar(15) not null, nome varchar(100) not null, faltas integer, PRIM...

asked by 29.08.2016 / 03:28

1

answer

Oracle SQL Error Invalid Number

I have the following query, which shows me date and time, recorded as default sysdate of Oracle: SELECT TO_CHAR(DATA, 'DD/MM/YYYY hh24:mi:SS') D1, TO_CHAR(DATA_FIM, 'DD/MM/YYYY hh24:mi:SS') D2 FROM PCN_ROMANEIO_CHECK W...

asked by 26.08.2016 / 16:11

Questions tagged as 'sql'