Questions tagged as 'sql-server-2008'

Tagged questions
1
answer

TDBXTypes.DOUBLE error with Delphi

I have this error I can not solve it, search in many forums but I can find a solution. I am developing in delphi a client-server program with datasnap. This error appears when I execute an INSERT procedure on sqlserver: Client side scri...
asked by 17.05.2018 / 04:35
1
answer

Error SQL Server 2008 NUMERIC_ROUNDABORT

I have several SQL Server 2008 servers installed on several machines that perform information synchronization processes every night. All work correctly except one that was recently installed in which I get the following error: INSERT error b...
asked by 12.11.2017 / 10:03
1
answer

Insert in SQL fields not null

Hi, I have the following question. It's something very basic but now it has me stranded. I want to make a query to a table from sql server managment. The problem is that I have the Id that turns out to be primary key, not null and it is self-inc...
asked by 18.10.2017 / 21:30
1
answer

How to update fields by querie of databases of different servers?

Good day, I hope and you can help me. I have 2 databases that are located on different servers, my idea is to update some fields through a query, however they are on different servers, for example I have one base on a server termination 192 ......
asked by 07.08.2017 / 18:43
3
answers

Casting of dates stored as Varchar

Good, everyone again requesting your support as I have a question about Casting a date, which is stored in the DB as Varchar with the following format 20161105 0207 , I need to make a cast of this DateTime , the first 8 digit...
asked by 13.12.2016 / 02:35
0
answers

FORMAT function used for numerical data does not work in sqlserver before 2012, alternatives

I'm using the format function to format a number, example: select format(45.123,'###############.00') print 45.12 select format(45.123,'###############.0') print 45.1 There is some way to do this in the previous versions of sq...
asked by 04.01.2019 / 21:33
0
answers

Subquery returned more than 1 value.This is not allowed when the subquery follows =,! = , = , = or when the subquery is used as an expression

ALTER procedure [dbo].[GuardarTicketCombustible] @Proveedor varchar(300), @CentroCostos varchar(40), @Departamento varchar(40), @ConceptoGasto varchar(40), @ProductoGasto varchar(40), @Vehiculo varchar(40), @PeriodoAcomodo varchar(300), @Moneda v...
asked by 29.11.2018 / 02:23
1
answer

Insert line break in SQL SERVER from PHP

I execute a SQL SERVER statement from PHP, and I need you to have a line break, since the SQL SERVER system requires them. PHP code: $QueryTable = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='$NombreTabla' AND xtype='U') CREATE TAB...
asked by 12.11.2018 / 19:32
0
answers

Error connecting pyodbc to external server

Hi, I'm connecting my application to an external database server sql server 2008 R2 and I can not connect, it gives me the following error    pyodbc.OperationalError: ('HYT00', '[HYT00] [unixODBC] [Microsoft] [ODBC Driver 13 for SQL Server] L...
asked by 10.11.2018 / 17:36
0
answers

How to return two or more selects by a stored procedure and how to receive them in a dataset using c #

It turns out that I have a stored procedure where I return two selects, simply and simply like doing a SELECT * FROM [NombreTabla] , one below the other. I from C # what I do is receive it with a DataSet in the following way: var re...
asked by 24.10.2018 / 17:53