Questions tagged as 'sql'

Tagged questions
1
answer

Dump Database

Is there a way to tell if a database has been DUMP ?     
asked by 12.09.2017 / 04:06
1
answer

How to bulkcopy an excel file into an sql table

I wanted to bulkcopy an excel file into an sql table. But it's giving me this error when I try to send to sql:    System.InvalidOperationException: 'The specified ColumnName' TransDate '   does not match any column of data source. ' The co...
asked by 30.10.2017 / 12:09
2
answers

Method that uses a random value as a parameter to change the characters of a string

I have this code that is working perfectly, but I need random values to appear in place of X. I want the returned result to be composed of random letters and that the position of uppercase and lowercase letters be obeyed according to the user in...
asked by 20.10.2017 / 17:36
2
answers

Select values that are not in another table

My scenario is as follows: Row Table IhavetheActivitytable I need to mount a select, taking the values from the queue table, but I need to exclude from the queue the values that already exist in the activity table. If in the activi...
asked by 28.10.2017 / 15:28
1
answer

Using sql_cache in MySQL query

When I learned MySQL, I was advised to use the expression sql_cache after SELECT , something like this: "SELECT sql_cache * FROM tabela..." Since then I started to use this in my codes, but it was never very clear to me what th...
asked by 25.10.2017 / 20:54
1
answer

Encrypting Function Script and Procedures in MSSQL

One question, I have some custom functions and procedures, and I do not want my client (who has access to the bank) to mess with their script. Does anyone know of any native way of MSSQL to encrypt these codes?     
asked by 01.08.2017 / 16:15
1
answer

SQL: MAX (date) with wrong results

Good malt, I have a problem, when searching for the highest date grouping by id, I get wrong value in the obs field. Query in use: SELECT a.n_func,a.id_sk, a.data, a.obs, b.maxdata, b.obs FROM chklist a INNER JOIN ( SELECT n_func, id_sk...
asked by 07.12.2016 / 16:26
1
answer

ODBC PHP / Oracle - UPDATE, INSERT, DELETE

I'm in a project using PHP and Oracle. the connection is OK, with this code I can execute all the selects I normally need, which I can not execute are INSERTS , UPDATES and DELETE . Could anyone tell me why? <?php requ...
asked by 20.12.2016 / 17:19
2
answers

Using LINQ to query a collection

about min: I come from JAVA and recently I'm learning C #, but I have a question about using LINQ. Many tutorials speak of the wonder that is LINQ but I can not understand its usefulness so far. Look at this code below: class Program {...
asked by 12.12.2016 / 20:14
1
answer

Delete select value comparing to another table

Good morning, I'm developing a scheduling website, however, I'm having a hard time trying to display only the times that are available. Explaining: There is a schedule Agendamento´, onde fica registrado o horário de inicio horainicia...
asked by 19.11.2016 / 14:45