Questions tagged as 'sql'

Tagged questions
0
answers

Data Flow Task Generates Blank Excel File - SQL Server Integration Services

I have a process in SSIS that takes information from a table and exports to an xlsx file. It happens that when running the Job through SQL Server Agent, the file is often generated in white, even though it has content in the table (this is not a...
asked by 11.12.2018 / 14:43
0
answers

PHP - Queries to print links in the nav-bar in a loop

For ordinary users I have 10 queries (nav-bar default) and for registered users I have 30 queries (nav-bar default + nav-bar related to the user page), just to print on the screen the link to querystrings , a guy told me that I should escape the...
asked by 11.12.2018 / 01:39
1
answer

How to change a primary key for constraint Auto_increment

I've created the following table create table if not exists cursos( nome varchar (30) not null unique, descicao text, carga int unsigned, totaulas int, ano year default '2018' )default charset = utf8; After adding a PK alter table curs...
asked by 28.11.2018 / 13:46
1
answer

Join show later dates only

I have a table that records steps of a move. For example: Data - Movimentacao - Produto 2018-01-10 - produzido - id1 2018-01-11 - embalado - id1 2018-01-12 - despachado - id1 2018-01-10 - produzido - id2 2018-01-10 -...
asked by 26.11.2018 / 14:30
1
answer

Postgresql connection with JDBC in eclipse

Appears on the console: java.sql.SQLException: No suitable driver found for jdbc:AulaFBD://localhost:5432/TrabalhoFBD at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager...
asked by 26.11.2018 / 04:53
0
answers

SQL - Trigger to send email when update is performed

Good morning, I need help on the following: I have a trigger to send email when an update is performed, but I have a problem! Whenever the table has update it is an entire grid that loads and sends emails to all rows that contain the close...
asked by 23.11.2018 / 10:05
0
answers

SQL link Problem of logic between two vectors

I have a logic problem that is as follows:    A: Main Key   B: Foreign key   C: Foreign key       Column A = [A, B]   Column B = [B, C] I need that when something from column A is equal in Column B, that relation returns me C. Thus, b...
asked by 21.11.2018 / 23:21
3
answers

C # - Knowing the location of the database file dynamically

I'm doing a program using C # in WPF, and I need to access the database dynamically, in this case I'm using a .mdf file. In code I have the connectionString like this: string stringConexao = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilenam...
asked by 24.11.2018 / 00:12
0
answers

Feed and view data from a bank VIEW on the system in php

I'm developing a simple system in which in my home.php , I have a table that will be fed by a VIEW of my database. But even modifying in my CRUD , he gives me the following error when I register a room:    Fatal error: Unc...
asked by 19.11.2018 / 20:59
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13