Questions tagged as 'sql'

Tagged questions
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 / 21: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 12.08.2018 / 01:01
0
answers

how can I do that depending on the selected in a droplist save me in a different table of the database

this is the part of the jsp in which I do the validations <%@page import="Consultas.DAO_FINALCOMPLE"%> <%@page import="clases.FIANL_COMPLE"%> <!-- begin snippet: js hide: false console: true babel: false -->...
asked by 09.08.2018 / 23:34
1
answer

TEXTIMAGE_ON error in SQL

CREATE TABLE [dbo].[bosh] ( [sid] [varchar] (255) NOT NULL, [node] [varchar] (255) NOT NULL, [pid] [varchar](100) NOT NULL CONSTRAINT [bosh_PRIMARY] PRIMARY KEY CLUSTERED ( [sid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECO...
asked by 23.08.2018 / 02:26
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 / 06:20
0
answers

Time Intervals with Mysql

Hello friends I have a problem that I have been struggling with in the last few hours, it turns out that I have to graph the conversations that have not been answered, and these are the catalog from mysql, in a way: one day, 3 days, 1 week, a...
asked by 08.08.2018 / 22:58
1
answer

how can I fix it list index out of range

I have a query and that query only throws me a record and when I optengo I ask you to throw me the value that is in the position [0] for a in datos_estados: tabla_datos = [a["estado"], a["seccion"], 'Teorico'] for vuelta in range(mes_i...
asked by 08.08.2018 / 22:12
0
answers

I do not get the .net framework data provider for sybase 17 in visual studio

I'm trying to make a connection but there is no net framework data provider for sybase 17 and I have not found a way to install it     
asked by 08.08.2018 / 21:51
0
answers

Multiply an echo of PHP

I continue with the table of filtered by divs. Well, now I'm doing a SELECT that has two options "PVP with VAT" "PVP without VAT". In the WILE cycle, all the results come out depending on other selects and taken from a BD. What I need to know...
asked by 10.08.2018 / 07:30
1
answer

Error creating triggers with dbvisualizer

I am using the version of DbVisualizer Pro 9.5.6 and I am running the following sql command to create triggers . CREATE OR REPLACE TRIGGER "MYDB"."TG_T01_01" BEFORE INSERT ON T01 FOR EACH ROW BEGIN :NEW.FECALT_01...
asked by 10.08.2018 / 06:45