Questions tagged as 'sql-server'

Tagged questions
2
answers

Distinct query with INNER JOIN in SQL SERVER?

Good morning: I have two tables in which the one by means of the reference, and it makes the query well, but I want to put the other fields of my table entsal and that are equal to the reference, for example add names , tea de la table entsal....
asked by 25.07.2016 / 15:43
1
answer

Migrate SQL Server database to Oracle

I'm trying to migrate a database from SQL Server to Oracle , for this I'm using Oracle SQL Developer as suggested by the following Oracle Tutorial , which has the following sections: Connection: 1. Install Oracle SQL D...
asked by 02.06.2016 / 00:37
1
answer

How to put local -portable- database in c # (visual studio 2015, sql server compact)?

I was doing a system in c # , I had it connected to a database in access . But I realized that maybe I could not; Generate the installer of the program and pass it to another person. Someone told me to try to put a database of Sql Server Comp...
asked by 08.06.2016 / 03:49
2
answers

problem when comparing by date format

I retrieve a date from a record that is in the BD and it brings me in this format "07/01/2016 05:43:10 pm", then I compare that date to make a condition to update my record since it is the only field that can be different for all the other recor...
asked by 04.05.2016 / 17:06
1
answer

Parameter value is out of range C #

Good hope you can help me, I'm doing an insert but at the time of inserting I get the following error. Parameter value 3420590313.72700000 is out of range my Store procedure that performs the insertion is decimal (19,8) and the column that...
asked by 02.01.2019 / 23:17
2
answers

Sql Server Update Column from another table

I have a table, where I need to update a data that is in another table according to a key, but it does not update the data correctly. Update KM_ficha set FichaActual = rtrim(ltrim(B.Idhistorial)) from KM_ficha A, [dbo].[base datos cliente] B w...
asked by 19.12.2018 / 14:09
1
answer

I have problems with INNER JOIN SQL SERVER

I'm new in what data base refers .. and I'm working with the issue of INNER JOIN and the truth is that I'm not very clear about how it works and how to apply .. since I have an exercise and I can not join a third table that is related .....
asked by 10.12.2018 / 21:08
1
answer

Trigger insert, update

Hi, can you help me with a trigger? I want that, if some data of the classifications table is moved, an insert is made if the data does not exist in the history table or, if it exists, only update the data. I have the code as follows: CREA...
asked by 20.11.2018 / 20:31
1
answer

How to do select with related tables

I have two tables (client) and (invoice), to register an invoice I am doing it this way: SqlCommand query = new SqlCommand("insert into factura (identificacion, nombrecp, " + "fecha, iva, tipo, vtotal, descripcion, subtotal) " +...
asked by 21.11.2018 / 04:35
2
answers

SQL Errror in group by [duplicate]

Hello friends, I'm trying to run the following query select x.[Nombre de empleado],x.[Sueldo diario],x.[Sueldo integrado],x.Total,x.conteo from( select em.nombreLargo [Nombre de empleado], em.sueldoDiario [Sueldo diario], em.suel...
asked by 31.10.2018 / 18:43