Questions tagged as 'sql'

Tagged questions
1
answer

Bulk insert into a table

I have two proc's that my system in VB already uses. One for Insert and one for Update. I need to use it right now, right in the bank. The target table has a composite key as follows. A field named ID_OIT_LET and another field called ID_OIT. ID_...
asked by 20.04.2017 / 14:18
2
answers

Incorrect syntax error next to engine

I would like you to help me. The following error is appearing:    MESSAGE 102, LEVEL 15, STATUS 1, LINE 17-SINTAX INCORRECT NEXT TO% with% But I did not find it. CREATE TABLE SITE ( SITE_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,...
asked by 19.05.2017 / 07:39
1
answer

What is the "function" in Oracle equivalent to a set generator?

I'd like to know, which command in Oracle would be equivalent to SET GENERATOR GEN_ID_TABELA TO 5; (command made in FireBird ) Because I would like to create a script with the inserts , but in order to avoid any errors...
asked by 19.05.2017 / 19:15
1
answer

Popular table in sql server with data coming from an excel spreadsheet

How do I create a script or via DTS , a way to populate a table in sql server 2014 , with information coming from a excel worksheet? The spreadsheet has several columns, but only two columns will be populated, and two other co...
asked by 18.04.2017 / 19:47
1
answer

Error when restoring external application bank asp.net mvc

I am trying to restore a SQL database that I created in a provider that does not have the WebDeploy option. And my goal is to initialize a database using ASP.NET MVC with EntityFramework . Well, when setting the server and...
asked by 17.05.2017 / 01:59
2
answers

Search and persons having the same name, surname and date of birth [closed]

How can I make a select in Oracle that brings all people who have the same name, surname and date of birth but have different ID's.     
asked by 31.03.2017 / 15:58
1
answer

Doubt in SQL Table

I created a table: Tabela Curso: Id int auto_increment nome varchar; Insert: Default, Arquitetura; Architecture has ID 1 in the table. Deleto the Architecture course. When I add any other course, it assumes ID = 2. Is it possible...
asked by 30.03.2017 / 17:00
1
answer

Select that does not return blank SQL

select 'TEM' AS InSituacao from GTCLogist where NrPlacaCarreta = '' and ID <> '35514' and year(DtBase)=year(GETDATE()) and MONTH(DtBase)=MONTH(GETDATE()) and DAY(DtBase)=DAY(GETDATE()) I have the above SQL, I need when the fiel...
asked by 17.04.2017 / 13:59
2
answers

Error in the codeigniter's querier builder

I have a SQL problem in my query, it follows: $sql = "SELECT cl.codigo, pa.codigo AS codigo_participante, pa.nome AS nome_participante, cl.usuario, cr.data AS data...
asked by 13.03.2017 / 23:32
2
answers

How to create relationship tables 1: N?

I have already studied database and understand how the diagramming of this type of relationship works, but now that I am trying to implement this database using sqlite3 and python I have seen some problems. I have the following database Theprob...
asked by 23.03.2017 / 18:22