Questions tagged as 'sql'

Tagged questions
1
answer

Integration Service does not appear in SSMS instance

I'm trying to install integration service on my server. Apparently it was successfully installed, the service appears in sql configuration manager, but the instance does not appear in sql management studio Does anyone know the solution?...
asked by 20.02.2018 / 19:20
0
answers

Generate random characters in SQL

Hello, I have a question in PHP My Admin that is as follows: I have a table that I need to put as a default value in a column a random value. Could anyone give me a light on this? I know how to do TRIGGER in PHP My Admin, the problem is...
asked by 19.02.2018 / 21:01
1
answer

Doubt in Perfomance in SQL

A question that has arisen now, and which I always see in one form or another in procedure SQL, is as follows: NOT TABELA.CAMPO IS NULL or TABELA.CAMPO IS NOT NULL . What's the difference in practice in performance issues, run time,...
asked by 26.02.2018 / 19:56
0
answers

How to add functionality to buttons

I'm new to php, and I'm doing a site manager, with it I want to manipulate the database, I'm listing the database's data and every bank item has three buttons to view; Edit, which will edit the name and Delete; but I do not know how to put funct...
asked by 25.02.2018 / 15:09
1
answer

List results cleared in the query

Good morning everyone, I need your help in a select, I'm doing a search, I have a 4 tables: user, question, alternatives and answer. In the answer table I save the user's cpf, the id of the question and the id of the alternatives, what I want an...
asked by 21.02.2018 / 14:35
0
answers

Query works in MySQL, but not in Laravel

I run a query on MySQL that works and on Laravel does not, follow SQL : select resource_id as "pedido", count(resource_id) as "perguntas", date_received from perguntas_pos where status="UNANSWERED" group by 1 order b...
asked by 18.02.2018 / 21:41
1
answer

How to bring all items that do not have reference to certain table [SQL]

I'm using NHibernate to do a sql query in C #, however I have a question. I have the following structure: public class Pessoa { public long Id {get; set;} public string Nome {get; set;} } public class Usuario { public long Id { //...
asked by 19.02.2018 / 19:21
0
answers

ERROR 1442 - Trigger AFTER INSERT - MySql

My database has the following structure: CREATE TABLE BAIRRO ( BAI_COD INT(4) AUTO_INCREMENT NOT NULL, BAI_NOME VARCHAR(200)NOT NULL, CONSTRAINT PK_BAIRRO PRIMARY KEY(BAI_COD) ); CREATE TABLE PAGAMENTO ( PAG_COD INT(2) AUTO_INCREMEN...
asked by 19.02.2018 / 01:24
2
answers

Compare shorter term between asp.net columns

Doing order system, I have several warehouses, let's suppose I have to compare 2 warehouses that have shorter lead times by using entityframework, how would I do that? I'm trying to do more but it only returns the last query value, but not the l...
asked by 18.02.2018 / 16:02
0
answers

INSERT with query in string Entity Framework

This is trying to give an insert in the table using a string containing a sql code ... when I use the DELETE command it runs perfectly now when I squeeze the insert no ... the insert runs straight into the database. Follow the code: public voi...
asked by 16.02.2018 / 21:08