Best answeres tagged with sql

1

answer

how do I make a multi delete

I have the following query DELETE Proyectos, Observaciones, Fechas_revisiones, Residentes, Revisores_anteproyectos, Validar_anteproyectos, Valid...

asked by 18.06.2017 / 15:20

1

answer

How to get the number of the day of the week PL SQL ORACLE regardless of language

The idea is to be able to get the number of the week in a function in ORACLE but that it will always return the same values regardless of the language configuration so as not to give wrong calculations in the dates, for example Spanish: L...

asked by 02.06.2017 / 17:27

1

answer

Update field with a specific condition with trigger

I have the following situation I would like an idea of the condition that could be put in a trigger so that when you insert an ISR422 for example 1.1 the date is updated automatically of the one that has an isr422 = 1, that is, both would have t...

asked by 20.07.2017 / 22:55

1

answer

Is it possible and how to transpose results from a column to rows dynamically? SQL Server 2008 R2

asked by 03.07.2017 / 18:29

2

answers

Return a data from a stored procedure in Oracle

I have this stored procedure: create or replace procedure spu_modificarTrabajador ( tnombre varchar2, tapellido varchar2, tid_cargo number, tdireccion varchar2, trut varchar2,tsueldo number, tcorreo varchar2, tcomuna number) is begin updat...

asked by 02.07.2017 / 08:52

1

answer

How to insert date data from pc to sql

I have a TextBox that captures the date of the machine using this code: TextBox1.Text = DateTime.Now.ToString ("dd / MM / yyyy") I have a field in my sql table named Date of type date When I try to insert the data insert into...

asked by 24.07.2017 / 21:56

3

answers

Get a word from a string in SQL Server 2008

I have a varchar field that contains a string with the following: "The Scenario is BUDGET; the Year is 2018; the period is June" The values of Scenario , Year and Period may vary. I am building a script, and part of w...

asked by 24.07.2017 / 21:28

1

answer

Doubt when performing an SQL query for an advanced search engine

Good afternoon. I am doing a website and a database for my practice, together with a colleague. Among the functions of the web, there is an advanced search engine, with several options. My problem arises in making a concrete query between...

asked by 16.05.2017 / 15:26

2

answers

Vector repeats the data of a query

my problem is that I have the following query: SELECT respuestaId, respuesta, estado, r.preguntaId FROM respuestas r, preguntas p WHERE r.preguntaId = p.preguntaId AND r.preguntaId = 1 The result of the query is 4 responses, for exa...

asked by 07.09.2017 / 03:27

1

answer

How to pass excel data to a SQLServer table with visual c #?

I have the following code on a button, but when I run the program I get the following error: Format of the initialization string does not conform to specification starting at index 54. no controo argument exeption: Here is the code...

asked by 19.04.2017 / 16:34

Questions tagged as 'sql'