Questions tagged as 'sql'

Tagged questions
2
answers

Query Transact Sql - SubSelect

I have an sql query that I can not determine, ( SELECT ( SELECT e.nombre FROM [Control_Documental].[dbo].[Etapa] AS e WHERE e.idEtapa = etd.idEtapa )AS etapa FROM [Control_Documental].[dbo...
asked by 23.09.2017 / 00:33
0
answers

PHP Mysql connection in web server with external server database [closed]

The truth that I write this question clarifying that despite having experience programming PHP and mysql, I now have to do something that I had not previously asked, so I need to be able to guide me about what information to look for or read to...
asked by 05.10.2017 / 02:34
0
answers

Joomla and databases [closed]

I'm about to start a project and I've found myself with joomla, but I'm wondering if it's possible to use SQL with joomla? the project belongs to a company which will hardly change its database managers, so I would like to make sure that SQl is...
asked by 05.10.2017 / 04:00
1
answer

Doubt MySQL Foreign Key

First of all, I'm not an expert, much less with SQL (I'm just taking my first steps on how it should be used correctly). Of course, you can understand if I make serious mistakes. The doubt is the next one: I have 3 tables: networks, people, vend...
asked by 21.09.2017 / 19:46
0
answers

Send SVG image in Email

I tried to send an image in SVG code so that a mail client interprets it as HTML and is visualized. The problem that only I see the image in a mail client, for the most part can not be seen. The way I send the code from sql server is as fo...
asked by 27.09.2017 / 01:24
1
answer

Complicated MySQL query between multiple tables

Greetings! The Query is about users, comments and the action on the comments (LIKE or DISLIKE). I try, but I do not know how to make the following return: comment data, user data, LIKE total, DISLIKE total, action action: this will be of t...
asked by 28.09.2017 / 01:39
0
answers

Copy and replace a table from one instance sql to another [closed]

Good day! I'm somewhat stuck with this situation: My system works with certain tables that I copy exactly from another system (another SQL server). Currently I do it manually (I compare the records that were modified on a certain date and replac...
asked by 27.09.2017 / 15:43
2
answers

Obtain a single data from two Oracle queries

I need to make a query, in which if a subquery returns a value null execute a second subquery which guarantees me to return a value the two subqueries return the same value. FIRST_VALUE (pac1.pac_name) -------------------------- |Oct/20...
asked by 27.09.2017 / 22:36
0
answers

How can I upload data from a flat file (excel) to SQL server express?

I tried to upload a flat file (excel) in xlsx and csv formats but I get the following error:    Mens. 4864, Level 16, State 1, Line 1 Data conversion error   of mass loading (type not matching or character not valid for the   code page specif...
asked by 09.10.2017 / 15:35
2
answers

sql query: Get roles that do not belong to a user

I have the following tables: La tabla usuarios con el campo Id La tabla rol con el campo Id_rol La tabla enlace con el campo Id_user y Id_rol En la tabla usuarios tengo insertado a "pedro" En la tabla rol tengo insertado "admin","usuario","mo...
asked by 07.10.2017 / 22:15