Good morning.
I have a table in Sql Server that contains Id , Nombre , Numero . The names can be repeated but each will have a unique id , I need to get the names that have the number ( Phone ) greater.
I attach...
Good afternoon, I am trying to generate a class schedule and it took several days without being able to generate the schedule through a query in MySQL.
The query I'm doing in MySQL is the following:
SELECT CONCAT(DATE_FORMAT(h.hora_inicio,"...
I am trying to create a procedure that receives as a parameter the user to whom they wish to grant the tables permission directly, I know that it would be better with a role and simply grant it, but it is an exercise, to create a procedure that...
I have two MySQL tables, the first with an id, name and the second with an id (related to the id of the first table) and a value.
I need to make a query that adds all the values with the same id from table 2 and shows it in a new column of table...
I want to update the data of a form using AJAX (jQuery 1.10.2) and the answer goes through the error.
HTML
<form name="formulario">
<p id="identificador">9</p>
<input id="opcion-1" type="radio" name="opcion" value...
Checking that all the data are filled in in the form to be able to continue with the application, I find the following error:
ene 08, 2017 9:14:27 PM interfaz.Alta_vehiculo button_OKActionPerformed
GRAVE: null
java.text.ParseException: Unparse...
I have a problem with this subquery.
I have in a table two id, cveLider and cveOperador that are related to cveEmpleado , I have to get the name of both, I did it through a subquery but I get the error
ERROR 1242 Sub...
This PROCEDURE is done in the MSSQL database engine and I need to pass it to ORACLE 11g:
CREATE PROCEDURE [dbo].[Insert_User]
@Username NVARCHAR(20),
@Password NVARCHAR(20),
@Email NVARCHAR(30)
AS
BEGIN
SET NOCOUNT ON;
IF EXISTS...
I did a multicary program but with mysqli to do tests since they do not let me take information about the work, where you work with sql server and when passing the connection and other statements in the php to sql server I get this error:
...