Questions tagged as 'sql'

Tagged questions
1
answer

Performance when comparing Varchar fields in SQL Server

% w / o% down is causing a lot of slowness because I use Right(L.nrDiscado, Len(D.Descricao)) (I believe) to compare with the SQL field: create table #TempNrDiscado (NrDiscado varchar(150)) Insert into #TempNrDiscado Select dist...
asked by 27.12.2016 / 13:33
0
answers

SQL query for ASP.NET page with C #

On my client's site, I have a SQL query that brings the readiness result of multiple collaborators. However, for the moment I can only translate the result of the query into a GridView: SQL CONSULTATION SELECT codigoAvaliacao, codigoColab...
asked by 18.01.2017 / 18:08
1
answer

SQL - Import data from a file

Hello, how are friends? I'm having a problem importing a previously created table: The following return message when I try to perform the import in MySQL: Static analysis:    3 errors were found during analysis.       Unexpected cha...
asked by 18.01.2017 / 04:18
2
answers

Show on the page the total number of id's registered in the BD

There is a table that shows all the BD records, but on a page of my project where I should show the record total (id) of my table. Connection file: <?php $mysqli = new mysqli("localhost", "house863_teste", "teste", "house863_registro");...
asked by 24.12.2016 / 18:36
0
answers

SQL Select inside a select with condition

I have 3 tables in the database to control a "news portal", where the tables have the following functions: news - > News Table gallery - > Table with images used in news relationship - > Table relating news stories to images...
asked by 19.12.2016 / 19:20
0
answers

Send a set of accumulated data to the bank during the day, is it possible?

I had a question, to store data of events and navigation that the user performs in the site, it would be possible to only send to the bank after the end of the day, the actions that the users performed during the day, or save only when it close...
asked by 19.12.2016 / 21:30
2
answers

Query creation with Union ALL to merge tables with indexing by table name

I have a problem that they made in a database, which I need to solve temporarily, they created several tables with index in the table name, where the system creates a new table with each new user ... probably the developer created this new probl...
asked by 09.01.2017 / 14:17
1
answer

syntax CAST sql command

I'm doing an INSERT through netbeans. I would like to know if anyone can tell me what the correct CAST syntax is when you need to convert two values to the same command. I tried insert into (minha tabela) (nome, senha) values cast(? as cha...
asked by 06.01.2017 / 19:47
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
0
answers

Fulltextsearch in SQL Server

Hello! Is that okay? I need to query the fulltextsearch because it needs to be indexed. However, I am not able to set up a query that returns all possibilities, as if it were a like . The query I was able to mount is as follow...
asked by 17.01.2017 / 19:31