Questions tagged as 'sql'

Tagged questions
1
answer

App UWP connects SQL Server 2012 without WebService?

I need to develop a UWP application in C # / XAML for use in the industry for data collection via Lumia 640 XL mobile phone with Windows 10 Mobile. All persistence (CRUD) will be in SQL Server 2012 on the internal corporate network. The app will...
asked by 27.09.2017 / 22:08
1
answer

Convert date entry with oracle

I'm having trouble returning the results of the following query, where I put the & month variable, if I put '01 -sep-2017 'would bring the results I need, but in the dialog box I wanted the user is typed with the patterns used for date, bein...
asked by 18.10.2017 / 14:35
0
answers

Creating table schema with pre-defined keywords

Hello, I am creating a table schema that needs to be optimized, the reason for this being tables that will have 3 to 5 million records. The big concern here is with regard to search, in this case the famous LIKE %% ... can not even pass close, be...
asked by 23.10.2017 / 05:46
1
answer

ORA-01704: too string string literal

I have a field of type CLOB in the DB, but when I give an INSERT it returns an error saying that it exceeded the size of the field that is 4000 characters. Relatório de erros - Erro de SQL: ORA-01704: literal de string extenso demais 01704. 0...
asked by 19.09.2017 / 16:32
1
answer

Check items in the checkedlistbox

I'm programming in C # in Visual Studio 2015, and I have a form with a checkedListBox with names of several courses. (The registration is for a student). By marking and saving, it saves the student's enrollment in the students table, and pres...
asked by 30.08.2017 / 21:19
7
answers

Mounting a sql query by filtering data

I am trying to mount a report, where I need to list deleted documents, I have the following sql statement: SELECT id,nf,status,data FROM documentos For example I have the following results: Whenyou'rereadytheexcluded,itgivesmethefollowi...
asked by 31.08.2017 / 17:01
0
answers

SQL Server Error When converting VarChar to Integer type [closed]

FOLLOW THE ERROR Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value '280-64460-2' to data type int. SQL DONE USE TOXICOLOGICO SELECT NomeUnidadeColeta, NomeUnidadeColetaAlterar, Procedimento FROM dbo.Z...
asked by 02.10.2017 / 20:41
0
answers

Alter table in giant table

I need to perform an alter table operation on multiple fields in a table, and this table has more than a billion lines. One operation for each field takes approximately 2 hours and now it imagines for several fields. In development environmen...
asked by 30.08.2017 / 14:10
2
answers

Adds WITH query within another query - SQL Server

People, like adding the query below as a subquery. Query with WITH: WITH dias AS( SELECT CAST('2017-06-26' AS DATE) AS dia UNION ALL SELECT DATEADD(DAY, 1, d.dia) FROM dias d WHERE d.dia < '2017-06-30' ) SELECT CONVERT(VARC...
asked by 18.08.2017 / 20:01
1
answer

Sending an Array by POST with JSON for PHP

Next, I need to send an array by POST with JSON. I have read about JSON.stringify and in my PHP code I use json_decode, but in practice I am not able to apply. I'll put the code here and change it more or less with the idea that I hope, even wro...
asked by 13.08.2017 / 23:49