Questions tagged as 'sql'

1
answer

Error form php to real server

I have a problem, and that is when trying to make a form to add values, the form stays on the same page .php and ignores any if or else .. Messages.php - > form: <form action="mensajes.php"> <input type="text" name="alias...
asked by 22.11.2017 / 15:17
2
answers

Save the value of a column in a variable using a WHILE

I'm trying to save a value in a variable. I create the table and insert records. CREATE TABLE #TEMP (IDSOL INT not null PRIMARY KEY ,USUARIO VARCHAR(50) ,LastName varchar(255) NOT NULL,FirstName varchar(255),Age int, ) INSERT INTO #TEMP V...
asked by 25.01.2018 / 20:10
1
answer

Clause CASE in PIVOT? SQL Server 2008 r2

Good people, I have this query with a pivot that gives me this data: DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX), @date1 AS NVARCHAR(MAX), @date2 AS NVARCHAR(MAX), @space NVARCHAR (10), @x NVARCHAR (10)...
asked by 16.11.2017 / 15:00
1
answer

how to know in which database is a sql server procedure?

Good I would like you to help me, I have 100 database and I would like to find a stored procedure, with a query to show me the location of the database that has that procedure: I have made this script but as long as I am in a specific databas...
asked by 11.11.2017 / 00:15
2
answers

Error in postgresql

I have a question about postgresql that does not allow me to move forward and maybe it's something simple that I'm forgetting or omitting. This is the structure of my table: CREATE TABLE public.p_proyecto ( id_proyecto INTEGER NOT NULL...
asked by 14.11.2017 / 15:30
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

Use ALIAS for conditional and operations of addition, subtraction, etc.

I want to compare the ALIAS hours with the ALIAS PlanWorkHours and assign the result to a new variable, however this is not possible since these ALIAS are temporary or do not represent as such a column of the table, there is some way to implemen...
asked by 26.12.2017 / 22:15
1
answer

Problems when making a query when grouping

I want a report like that friends: id descrip codigo nro idingreso bien bueno regular malo 01 aceite 2345 2 23 a 3 4 1 02 azucar 2345 4 34 b 2 5 2 I'm tryi...
asked by 08.11.2017 / 00:37
1
answer

Not Equals in the Where clause

I have the following tables create table Puesto ( id_puesto int identity(1,1) primary key not null, piso int, cantidad_sillas int, frente_ventana bit, cantidad_computadoras int, cantidad_sillas_adicionales int, acce...
asked by 28.10.2017 / 00:09
1
answer

Error expanding PHP / MySQL details

In PHP / SQL, I have to show the details of some employees of a company, which are stored in the MySQL database. Right now, the code that I have developed is the following: employees.php <?php $host = "oraclepr.uco.es"; $username =...
asked by 25.10.2017 / 14:39