Questions tagged as 'sql-server'

Tagged questions
0
answers

How to put a field of a horizontal select in sql that does not duplicate data SqlServer

select Paciente= HC.IdPaciente , Fecha_Adm = CONVERT(char(10), E.FechaAdmision, 101), Activo = Case when E.Estado = 'Activo' then 1 end, Anulado = Case when E.Estado = 'Anulado' then 1 end, Estado = Case when E.Estado = 'Anulado' then 'Solo Anu...
asked by 29.10.2018 / 20:32
0
answers

SQL Trigger in Stroed procedure - activate trigger after using sp

Suppose I have a very simple stored procedure , which performs a select , but I want to make a trigger that is activated every time I use that stored procedure . Does anyone know exactly how to do something like that?...
asked by 27.10.2018 / 01:40
0
answers

Error with dependent dependent php, sqlsrv, jquery

I wanted to exercise with this library sqlsrv since with mysqli I worked without problem the exercise of the dependent select for regions, provinces and communes. My problem is the following I do not know how to debug with jquery in order to cap...
asked by 26.10.2018 / 08:08
1
answer

I can not get and send the data id of a combobox in JAVA pattern MVC to SQL

THIS IS MY JSP "INSERT": <% ProfesionalBE profesional = new ProfesionalBE(); profesional.setNombre(request.getParameter("nombre")); profesional.setApellido(request.getParameter("apellido")); profesional.setCorreo(request....
asked by 27.10.2018 / 01:33
2
answers

Convert from Date and Time only Time and Minutes in SQL

Good morning I have this query convert(char(8), Horario.HoraInicio, 108) but when I give it run I get 00:00:00 but yosolo I want me to% of 00:00 some idea, Thanks     
asked by 23.10.2018 / 18:29
0
answers

Enable Inputs According to a select - PHP- SQL SERVER

Cordial Greeting, I hope you are well and can help me with what I want to do: I have a Select, loaded from a database: include'conexion.php '; $sql = "EXEC SP_COMBO_PAGADURIAS"; $stmt = sqlsrv_prepare($conn,...
asked by 23.10.2018 / 18:38
0
answers

Error filling input with Json and sqlsrv

The system must fill in the input fields once the routine is entered but it does so and I do not see any type of error. index.php <!doctype html> <html> <head> <meta charset="utf-8"> <title>Ingresar clientes<...
asked by 22.10.2018 / 22:41
1
answer

sql query showing a repeated record

I have the following query that I do in SQL server select celular, razon_social FROM clientes where celular <> '' AND LEN(celular) = '10' AND ind_estado = '1' AND ISNUMERIC(celular) > 0 ORDER BY celular it brings me records norm...
asked by 23.10.2018 / 23:45
0
answers

As I send fix with an insert

I want to make an insert to the database, but the data I want to send are fixes, I wanted to know if they help me how to send those fixes to the INSERT I'm working with PHP and SQLServer This is the table that I have and depends on the inputs th...
asked by 21.10.2018 / 22:56
0
answers

Problem in inserting an intermediate table

I come to bother you with a problem I have these three tables Boarding vuelo documento tipodocumento luggage nroequipaje peso luggagepacker nroequipaje documento tipodocumento I'm doing a program in visual basic and I hav...
asked by 20.10.2018 / 02:02