Best answeres tagged with sql-server

2

answers

Problems connecting to SQL Server database [duplicated]

I have the following code: public static int Guardar(string codigo, string nombre, string apellido) { Clase_Conexion conexion = new Clase_Conexion(); int retorno = 0;//existe codigo. Producto repetido String sql="INSERT into Tab...

asked by 22.03.2017 / 20:01

1

answer

Get a certain day of the week between a range of dates in SQL [closed]

How to Get the dates of a certain day of the week between two dates. Example: All the dates of the Monday days between the range of 2016-01-19 to 2016-02-19 Reputed: 2016-01-23 2016-01-30 2016-02-06 2016-02-13 This is what I am doing but I am...

asked by 19.01.2017 / 16:47

1

answer

Stored procedure invoking dll

I have to create a stored procedure that receives one parameter and returns another. Within the procedure I declare a variable and give it value with a select. Later with the input variable and the one obtained from the select I invoke a dll. I...

asked by 22.11.2016 / 11:55

0

answers

How can I link a database in Visual Foxpro to a SQL Server 2014 server? [closed]

I have a database in Visual Foxpro and I can not have it as a linked server in SQL Server 2014 because the Visual DBPro Ole DB Provider is 32 bits and it does not talk to 64-bit SQL Server 2014. Has anyone managed to link the server with another...

asked by 31.03.2017 / 02:23

2

answers

Report three nested tables

asked by 11.12.2017 / 12:43

1

answer

How can I recognize these 4 characters between "[GS]" as SQL and not as PhP?

In the following php query but it does not allow me to remove this [GS] that is in brackets within the table as a record (NOTE: Below I leave a small Photo SQL Capture of my doubt I appreciate answers I think the picture explains better.) $r...

asked by 16.07.2016 / 16:26

1

answer

Select to records that do not contain value in table [closed]

I have the following table Pedimento | Partida | Identificador | Valor Agregado 6000001 | 1 | TL | 10 6000001 | 1 | PT | 10 6000002 | 1 | TL | 0 6000002 | 2 | XP | 0 6000003 | 3 | PT | 10 6000003 | 4 | TL | 10 How can I perform a query that...

asked by 11.02.2017 / 06:54

2

answers

How to convert the month of the date to text?

I want my months that are numeric to be displayed in text, but I do not know the correct way to use the datename. Thanks SELECT SUM(AU.Tarifa_Diaria) AS [TOTAL],MONTH (AO.fTermino) AS [MES] FROM Arriendo_Autos AU INNER JOIN Arriendo_Solicitu...

asked by 31.10.2018 / 13:20

2

answers

Trigger so that it does not update the stock when it is 0

Hi, I want to make a trigger that when the stock of my inventory is less than or equal to 0, it does not allow me to sell more product but it still subtracts them anyway. create trigger NoProductos0a on InventarioProducto for update as decla...

asked by 10.05.2018 / 19:05

1

answer

Delete repeated fields sql

Could someone give me a hand with my code? select nro_viaje into #vviajes from [ARROSWKS604\SQLEXPRESS].[Test].[dbo].[Hoja1$] select nro_viaje, cod_cliente into #cclientes from [ARROSWKS604\SQLEXPRESS].[Test].[dbo].[Hoja1$] Select distinct...

asked by 27.04.2016 / 22:01

Questions tagged as 'sql-server'