Questions tagged as 'sql-server'

Tagged questions
1
answer

Add rows to an asp datatable filled from a database

In my application I have a data table that I filled from a database registry, taking the following method: Public Shared Function RetData(query as String) As DataTable Dim conn As New Connection() Dim tabla As New DataTable() Try...
asked by 19.11.2016 / 17:20
2
answers

Google maps mark with points from the database

I want to get the points, name and description plus 2 values to add to the snippet, but when I run the code I have the app does not fall, but it is black, then I leave my code public class Marcadores { String ip, db, un, passwords; Co...
asked by 01.11.2016 / 22:07
1
answer

'FOR' cycle in SQL

I have a query in sql which columns of the result table are the months of the year: January - December. DECLARE @Ventas MONEY declare @i int declare @ano int declare @mes int set @ano = 2016 set @mes = 12 set @i = 1 WHILE @i <= @mes BE...
asked by 27.10.2016 / 17:27
2
answers

I do not work the tables made in MySQL on Microsoft SQL Server 2014

SET SESSION FOREIGN_KEY_CHECKS=0; /* Drop Tables */ DROP TABLE IF EXISTS SE_COMPONE; DROP TABLE IF EXISTS ARTICULO; DROP TABLE IF EXISTS PEDIDO; DROP TABLE IF EXISTS CLIENTE; /* Create Tables */ CREATE TABLE ARTICULO ( num_serie numeri...
asked by 04.01.2017 / 21:43
2
answers

Modify SQL query to obtain expected results

Background I am generating a series of reports based on information contained in a database in SQL Server. For purposes of the question, I will call this database: Test . From the Test database, I get the time at which certain user...
asked by 29.09.2016 / 19:08
3
answers

SQL Server 2008: join statement throwing incorrect results

I'm trying to merge these two tables Table Product : +-------------+-------------+-------------------------------------------+----------------------+----------+-------+------------+-------+------------------------+----------+-------+------...
asked by 08.11.2016 / 20:23
1
answer

Generate .bat to execute SQL Server queries

I have the following series of questions: delete from OPENQUERY (MYSQL, 'SELECT * from clientes2 WHERE IDCliente>2') insert into OPENQUERY (MYSQL, 'SELECT IDCliente, Grupo, Codigo, Denominacion, CUIT, TipoCliente, Responsable1, Activo FROM...
asked by 03.11.2016 / 18:18
2
answers

The input string does not have the correct format. C #

First of all sorry for so many questions that for many of you must be insignificant things I imagine, (apprentice mistakes say) The subject is like this: I have properties, each property has date ranges (start date and end date) I did the follow...
asked by 15.07.2016 / 23:03
2
answers

SQL Server Agent in SQL Server 2005 Express

I have always made Maintenance Plans in Sql Server, I have always done them in 2008 and now I have to do it in 2005. The problem is that I can not find in Sql Agent, how can I enable it? Or outright is not possible in this version of SQL.     
asked by 09.08.2016 / 17:50
3
answers

Convert text field to DateTime in PHP

I want to make a query to base de datos in sql server where the field is of type datetime. At the moment of doing this in PHP it shows me the following error:    Warning: strtotime () expects parameter 1 to be string, obj...
asked by 25.07.2016 / 20:07