Questions tagged as 'sql-server'

Tagged questions
2
answers

Return 1 pair by SQL Id SERVER

I have the following query SELECT IdentificadorAutomovil, Automovil.Titulo, Automovil.Precio, Automovil.Anio, Automovil.Kilimetros, Automovil.Ubicacion, Imagenes.Imagenes FROM Automovil INNER JOIN Imagenes ON Automovil.IdentificadorAutomovi...
asked by 21.09.2017 / 16:22
1
answer

Load a JList with data from an array

Hi, I have my class Gestor with the following code: Class gestor { private final String cadena = "jdbc:sqlserver://localhost:1433;databaseName=Persona"; public final String usuario = "mi_usuario"; public final...
asked by 23.08.2017 / 23:15
2
answers

Create a TRIGGER to insert a record in a table

I have three tables Detalle_Compra , Detalle_Venta e Inventario : CREATE TABLE Detalle_Compra ( Pedido int, Producto int, Cantidad int not null, Precio int, foreign key (Producto) references Productos, foreign key (Pedido) r...
asked by 08.09.2017 / 00:36
2
answers

PHP date error

Hi, I'm doing an application with php codeigniter and sql server 2000. I try to make an insert to the bd and insert the data but the date you are saving is: 1894-07-07 00: 00: 00.0 (datetime) instead of the current date. this is the code:...
asked by 26.09.2017 / 16:29
1
answer

select * from @variable? - select a variable

I made a pivot (dynamic) and the result I store it in a variable, to show the result I made the following instruction: exec (@queryimiu) The result of the pivot I want to store it in a table called NewTable: SELECT * INTO NuevaTabla FROM...
asked by 14.07.2017 / 19:20
2
answers

Import CSV to SQL Server 2012 With descriptive fields with commas

I have a .csv file that I need to import to sql server 2012. I have already created the table Then perform the insert. The problem I have is that in the table there are descriptive fields that have commas within themselves, for example in the...
asked by 17.07.2017 / 09:30
1
answer

Extract value in datalist

As I can extract the value of the query in my DataList , I have the following fragment in my page aspx <div class="form-group"> <label for="" class="col-md-2">País</label> <div class="col-md-4"><input class...
asked by 28.06.2017 / 17:34
1
answer

The date data is repeated

I have this query in SQL Server: SELECT r.id_referencia ,t.id_tipo ,o.id_operacion ,p.id_provincia ,s.id_superfice ,pr.id_precio ,v.id_vendedor ,f.id_fecha FROM vendedor v JOIN Inmuebles i ON v.nombre_vendedor = i.v...
asked by 28.06.2017 / 22:56
2
answers

Trigger SQL Server insert record if certain field is updated

Good afternoon colleagues I have this trigger to insert a record but only if the teststatus field changes, but even if there are other fields that are updated I still insert the record someone knows why create trigger trTestStatusInsertarAct o...
asked by 28.06.2017 / 22:54
2
answers

Multiplication in sql, error by INNER JOIN

I have this Query SELECT SI_Articulo = COALESCE(t.SI_Articulo, c.SI_Num_Articulo), SI_Ubicacion = COALESCE(t.SI_Ubicacion, c.SI_Ubicacion), SI_OV = COALESCE(c.SI_OV,''), SI_Ubicacion_Fisica = COALESCE(c.SI_Ubicacion_Fisica,''),...
asked by 07.07.2017 / 21:12