Questions tagged as 'sql'

Tagged questions
1
answer

Write ListView in SQL Database using Entity Framework and C #

I'm developing a desktop sales application using C # and Entity Framework and am having doubts about writing the items inserted in ListView into the SQL database. How do I write the inserted items to ListView in my table tb_i...
asked by 13.08.2014 / 02:07
1
answer

Sorting rows in a table with SQL SERVER

I have a table (Customer) example: ID Nome Order 1 Joao 1 2 Ana 2 3 Marta 3 4 Joana 4 The goal is to sort the contents as follows: I get the ID (@ID) of the position to be changed and the new position (@novaOrdem) for th...
asked by 04.07.2014 / 10:35
1
answer

How to transform lambdas expressions into sql commands?

How can I manipulate expressions to help automate the creation of SQL statements like Linq to SQL? So: using EntityFramework I can make queries such as: var livros = contexto.Livros .Where(livro => livro.SaldoEstoque > 0) .Orde...
asked by 10.11.2014 / 23:24
1
answer

Delete in the table via Shell Script

I'm trying to do a delete of all rows from a table via Shell Script. The database is oracle. The bank for some reason does not let me do truncate and the delete simply does not delete, without presenting any error. I do not really know why, when...
asked by 24.05.2014 / 00:29
2
answers

Database and Android doubts

I'm developing a project for college that is about a multiplayer Android game for questions and answers (Style Asked). In game development, I need to create a database to store the questions, their answers, and the correct option. The game acces...
asked by 28.10.2014 / 13:39
1
answer

Select type of columns that come in a SELECT

Hello, my question is the following: I have a Select in SQLServer of two tables with inner join, they return a set of 5 columns. I would like to know how to list the type of these columns. I know that I can show the type of columns with...
asked by 17.06.2014 / 14:44
1
answer

Show null results through LEFT JOIN with Linq!

I have a SQL query: SELECT A.Codplano, A.Secao, A.Setor,A.Subsetor,A.Contato, ISNULL(B.Subord,'NÃO LANÇADA')AS Situacao FROM vwPLANODIN A LEFT JOIN LANCADA B ON A.Codplano = B.Subord and B.Data = '2014-06-10' WHERE B.ID IS NULL and A.Sitio =...
asked by 14.06.2014 / 17:21
2
answers

How to do a SQL query with some blank criteria? [duplicate]

I'm creating a filter for a database search in a PHP application and obviously I have a lot of criteria, but I've only managed to work with only one criterion. Code: select codigo, despesa, data, estabelecimento, valor from financeiro whe...
asked by 19.07.2016 / 04:56
1
answer

Mounting a 'frame' in html from an array in php

The tables: Science (eg Mathematics, Biology, Chemistry). Areas (eg Algebra I, Biochemistry, Botany, Chemical Bonding). Exercises (eg Water, Algae, Bryophytes, Progressions, Chemical Bonding). To use as in this example [Table 01] in h...
asked by 22.07.2016 / 17:09
3
answers

IF condition within a WHERE - ORACLE PL / SQL

Here is the procedure with the problem: CREATE OR REPLACE PROCEDURE NOVODIA.PRC_PACIENTES_INATIVOS_95 ( --PARAMETROS IN_CPF IN VARCHAR2, IN_CARTAO IN VARCHAR2, OUT_CURSOR OUT SYS_REFCURSOR ) IS --VARIAVEIS V_COD_CLIEN...
asked by 24.04.2014 / 17:10