Questions tagged as 'sql'

Tagged questions
1
answer

Recursive SQL using CTE

I'm mounting an SQL statement using    Message 530, Level 16, State 1, Line 5 The statement was terminated. THE   maximum recursion 100 was exhausted before the end of the instruction. SQL Server version:   Microsoft SQL Server 2016 (S...
asked by 03.10.2018 / 15:07
1
answer

Basic Commands

Good afternoon. I'm new to Database and I can not resolve this solution. Assemble a clause that performs UPDATE, for all employees who perform the "Computer Programmer" function, changing its function to "Programming Manager"     
asked by 28.06.2018 / 22:36
1
answer

About JAVA and HeidiSql

    
asked by 18.07.2015 / 17:46
2
answers

What are the differences between a PL / SQL programmer and an Oracle DBA? [closed]

Can one explain the differences between the PL / SQL programmer and the Oracle DBA ? I know there are many differences, but I'm not sure how to specify them. I have some doubts too ... For example:    Can a DBA program Procedures...
asked by 04.09.2017 / 16:31
1
answer

Foreign SQL Tables and Attributes

Good afternoon, I made a Sql code with the following tables: create table Bairro( cdbairro int not null primary key, nmbairro varchar(80) not null )default charset = utf8; create table Aluno( cdaluno int not null primary key,...
asked by 28.11.2018 / 19:13
2
answers

I have a QUERY that does not display what I really need

My Query: select id from clientes where cliente = '$cliente' AND status = '2' AND (tipo <> '0' AND (disponibilidade <> '0' OR vanual <> '0' OR vtemporada <> '0')) I need it to work as follows: You may see som...
asked by 15.03.2016 / 17:24
0
answers

Problem creating foreign key in mysql

Well I have to relate 3 tables and I am trying to create the foreign key I can only create that in php I have a INSERT for one of the tables that does not insert and accuse the following what I am doing wrong in Foreign key...
asked by 15.03.2015 / 02:01