Best answeres tagged with sql

0

answers

phpmyadmin icons do not work

I installed phpmyadmin and I have the problem of the icons / images, just as everything in the themes folder does not work. How much the permission of this folder stays the same as others drw-r-r-- 11 root root 4096 Feb 5 22:48 templ...

asked by 15.02.2018 / 15:41

0

answers

HRESULT error: 0x80020003 on sql server

I'm working with a Sql server database and it started to present a strange error, preventing me from accessing the design and creating new tables. I searched the internet and could not resolve this error.

asked by 17.02.2018 / 04:13

0

answers

Get the contents of the columns that are inside a while

Good evening! I'm trying to use the columns of the second while to insert into a table, but I can not get the value of the columns. I already used several combinations of quotes and nothing. Is this possible? DECLARE @query nvarchar(max...

asked by 06.02.2018 / 02:00

0

answers

Filter Results Equals Mysql

asked by 09.02.2018 / 01:38

0

answers

Error generating file in oracle plsql

When I try to generate txt file I get the directory error message. Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME linha from tfunciona...

asked by 09.02.2018 / 01:14

2

answers

What does the ^ = operator mean in C #?

I have a function in C #, where I decrypt a string and need to convert to a function in SQL Server for technicians to be able to work with the decrypted value. There is a foreach , which I do not understand how it works: var calculoChave...

asked by 27.01.2015 / 13:32

0

answers

I can not make left join and use GROUP BY

This is a system for selecting how many likes you have in each post! in the third image shows the relation of likes. of = user id and for the post id First image shows the result of how many likes each post has, but I also need to show pos...

asked by 10.02.2018 / 16:05

1

answer

Range set by SQL user

In sql, is there any way to define the range of a query according to the user's past? Example Number of days the user enters is 7, and set as the registration date 07/01/2018, the bank return the registration made on 01/01/2018 to 01/13/...

asked by 10.02.2018 / 01:24

2

answers

Left join or Sub-Select? Which one has the best performance?

I'm studying which of the querys below would perform better. So I wrote both and ran on the same database with the same data: Query 1: select a.numeroOp as OP, a.codigo as CÓDIGO, (a.qntAhProduzir + a.qntPara...

asked by 05.02.2018 / 18:32

0

answers

Dataset to Excel to MS Access

I have a certain dataset all in the same table, and I want to split it into a relational database in MS Access. I've been successfull to a certain degree but now I have a problem. My dataset had the products available in a certain store displ...

asked by 30.03.2018 / 00:18

Questions tagged as 'sql'