Questions tagged as 'sql-server'

Tagged questions
0
answers

Exception from HRESULT: 0xFFFFFFF8 vb .net

When wanting to read from the database with vb.net it marks me a exception , apparently because I am bringing data NULL . I'm new to sql server, this is my code I hope you can help me. Save the data of a fingerprint in sql...
asked by 20.04.2018 / 21:25
0
answers

C # migrate oracle data to sql server, problem with date

I hope you can help me, at the time of migrating in c # I have problems with the date. I do it in the following way and it causes me error.insert.ExecuteNonQuery (); DateTime hiredate; hiredate = reader.GetDateTime(5) insert.ExecuteNonQuery()...
asked by 16.04.2018 / 07:14
1
answer

Add total of several rows that have the same primary key from another table

Good morning, dear, I am looking for a bit of your help and knowledge regarding an SQL query, since I am giving my first tanes in this query language. I tell you, I have two tables that store invoice data, in one the header is stored, that is...
asked by 17.04.2018 / 03:14
1
answer

how to create a SQL table with dynamic columns

How can I make a dynamic SP where according to the data of a table1 I take them as columns to create a table2 these may vary . That is to say how there can be 1 or 2 there can be 10,20,30 ... I leave a SP to create a table CREATE PR...
asked by 13.04.2018 / 21:40
2
answers

How to insert multiple rows from a datagridview to sql server in c # using dataset

This is the Form in which I am working the idea is that you can select any checkbox and those you select are saved along with the data that are in the textbox above. First of all, the datagridview is full public DataSet llenardataDV(...
asked by 13.04.2018 / 04:01
0
answers

SampleCurrencyData.txt How to get it

Hi, I am following the series of tutorials from SSIS How to Create an ETL Package from Microsoft SQL Server Integration Services in Visual Studio but there is a part of which I could not pass and it is as follows: As you can see, it a...
asked by 15.04.2018 / 00:33
1
answer

Error in query SQL SERVER when trying to fetch a field

Good afternoon colleagues at work where I am placed to modify an SQL SERVER query where I must bring a field called ATR_DEPOSIT from a table called ACCOUNTING_TRANSACTION, the PRIMARY KEY field of this table is ATR_IDENTITY_CODE, it sounds very...
asked by 14.04.2018 / 21:22
1
answer

Error sql server: must declare the varialble scalar PO @ and

I edit the question. I'm creating a Jtable that feeds from a BD Sql server. The procedure for the query is this: private static final String SELECT_FILTRO_FECHAS="SELECT REPOSTAJES.ID, FLOTA.MATRICULA,REPOSTAJES.NUM_FLOTA,REPOSTAJES.FECHA,REPO...
asked by 12.04.2018 / 23:08
1
answer

Join two models in asp.net mvc 5 c # - N CAPAS

I have two models: public class TipoSolicitudesDTO { [Key] public int TipoSolicitudID { get; set; } public string NombreTipoSolicitud { get; set; } public int EstadoTipoSolicitud { get; set; } } public class Solicitudes...
asked by 09.04.2018 / 23:21
0
answers

Save fingerprint data in sql VB6

I have to "update" a fingerprint system that works with vb6 but the digital personal SDK is no longer handled in platinum but in one touch it is in platinum to make the connection and save the data was: Dim blob() As Byte Dim bv...
asked by 18.04.2018 / 20:38