Questions tagged as 'sql-server'

Tagged questions
0
answers

Show Image in php that is saved in sql

Hello Friends very good morning I have the following situation, I have an image saved in sqlserver with a column type image. I would like to be able to show it in php and I use the following code and I can not show it: error_reporting...
asked by 20.08.2018 / 15:45
1
answer

Generate PDF WITH SSRD

My doubt is that I have generated a group of 40 rows but the tablix still only generates 14, what I want is for the detail to be shown without repeating the header What I want to do is that the image 2 no longer appears but the detail is show...
asked by 15.08.2018 / 01:01
0
answers

Replication Sql Server 2008 R2

I try to enable the transactional replication with updatable subscriptions and it throws me an error, but I looked for information and it tells me to run the following procedure, but it does not work for me: exec sp_link_publication @publisher...
asked by 17.08.2018 / 13:11
0
answers

help with the run time problem in a query statement Dapper c #

That such friends I am working an application with c # using the orm dapper. in case it is that in certain occasions I keep a certain number of records in a single execution, approximately 400 records. the problem is that sometimes, I throw an e...
asked by 17.08.2018 / 01:58
1
answer

I return the value of Stored-procedure in SQL

I just made a Store procedure on sql server. This is the structure. USE [AuditoriasDB] GO /****** Object: StoredProcedure [dbo].[spFindOrInsertSucursalProveedores] Script Date: 18/08/2018 01:23:58 p. m. ******/ SET ANSI_NULLS ON GO SET QUO...
asked by 18.08.2018 / 19:28
1
answer

SQL Server 2008 Agent Failed login faild Error 18456 When I try to run a Job

I have several jobs but when I try to execute them or they run at the scheduled times I get the following error message, and changed the authentication mode to mixed but the error you got help. That is the error that presents me, thank...
asked by 11.08.2018 / 23:01
1
answer

how to create a function in SQL server to translate dates in 3 languages? [closed]

How can I create a function that receives 2 parameters a datetime and another the language. translate for example: Sunday 12 August 2018 English thursday 12 August 2018     
asked by 13.08.2018 / 04:20
0
answers

Export sql server records to several excel files

I have problems exporting records in several excel files, due to the maximum restriction of excel, I can only export 1,048,576 rows, I have thought to perform the division of records per year and per month, in order to reach in several tabs , bu...
asked by 09.08.2018 / 15:06
1
answer

correct use of having by [duplicate]

Hi, I wanted to know if I'm doing the right thing with the following tables NUMOBJ | IDIOMA 1 | E 1 | I 2 | E 2 | I 3 | E 3 | I table1: each object with all possible languages (2) NUMOBJ | IDIOMA 1 |...
asked by 12.08.2018 / 17:42
0
answers

the javascript parameter is not recognized by the php query

function prueba(){ var prueba=2; // var usu=document.getElementById("usu").innerHTML; $.getJSON("json/ingresar.php", {prueba:prueba}, function(resulta){ var valor = JSON.stringify(resulta); valor2 = JSON.parse(valor);...
asked by 02.08.2018 / 14:06