Questions tagged as 'sql'

Tagged questions
0
answers

Verify ID before registering it in BD

I need a little help :(, I am just practicing these queries and I have a problem when verifying the existence of an ID (rut) before registering it in my database ... but the filter does not work: [ This is my code: $votador = $_POST['rut'];...
asked by 08.11.2018 / 21:40
1
answer

How to get the MAX and AVG in Oracle? [closed]

As I can get the maximum and the average of 2 columns the fields are: name, price, quantity. I want to get the maximum and the next one by category     
asked by 08.11.2018 / 19:01
1
answer

Exception when registering C # SQL [duplicated]

I want to register movies, where you have the fields: txtname, txtanio, txtweb, txt description. In the database the Id is incredable. But when I press the high button I get the following error: And the following code for when y...
asked by 08.11.2018 / 01:59
1
answer

ASP how to send ID to a form

What I want to realize is that each time you select the edit button as shown in the image Redirects me to a form where the input captures the selected data For example, if I select Edit Truck, it appears in the truck editing input...
asked by 07.11.2018 / 15:15
0
answers

sql query by multiple MYSQL columns

I want to consult by several columns with a concatenated value, I put the following example to make me understand -- Como se llamaría => CALL sp_getSuperConsulta("%val1% %val2% %val3%"); DROP PROCEDURE IF EXISTS sp_getSuperConsulta; DELIMI...
asked by 20.11.2018 / 23:24
1
answer

Align concatenated column in a query in SQL Server

I have this query: SELECT A.CODIGO_MINSA, A.DESCRIPCION, B.DESCRIPCION AS COLEGIO, A.CODIGO_MINSA + ' - ' + A.DESCRIPCION + SPACE(60 - LEN(A.DESCRIPCION)) + '- ' + B.DESCRIPCION AS PRESENTACION FROM [HEVES_RRHH].[dbo].[T_TIPO_ESPECIALIDAD...
asked by 06.11.2018 / 16:19
1
answer

How to make a sql-server 2008 connection in php when it is already on a web host?

I already made a connection to sql server from xammp and it works perfect, the question is how should I change the connection parameters to access from a web host on the internet? what ports should I open or what ip should I put? I hope you can...
asked by 06.11.2018 / 05:24
1
answer

How to capture in an SESSION variable an element when clicking on it?

I do not know how to express my question but the issue is this, I'm doing a job for a course which I'm taking but I'm at a standstill, the work basically consists in making a simple "copy" of a social network, These are the requirements that the...
asked by 26.11.2018 / 00:46
0
answers

VBA Access - Error in product search engine

I am preparing a product search engine in a table. I want to know if there is a product unless it meets the given condition. If in the input of the function I put a 'c' I would like to know if there is at least one record that contains a text...
asked by 05.11.2018 / 16:02
0
answers

SQL Server query - List best clients

I want to list the best clients by region of the northwind table. For this I did this select ContactName,r.RegionID,sum(Quantity) as 'Cantidad comprada por el cliente' from Customers c join Orders o on o.CustomerID = c.CustomerID join [Order...
asked by 09.11.2018 / 04:30