I am making a query in SQLServer where I require the record of days worked of x number of employees.
On the days when they are at Rest, they can work obtaining the additional day.
The query I have generates the following
id cliente pues...
I have this code which I want to access to the QR part, in order to generate one, but at the moment of creating a record in RecordEvent when I send it to call AltaQRBoleto (1, Correo); (In spite of sending him to call twice) he does not take any...
I have a record in a table called PARAMETRI that has an autoincrement field named idparametri . What I want to do is save a record in a table called OBRA ; that table has a field called PARAMETRI_ID_PARAMETRI and I want...
Greetings guys I need help with the following:
I have a table with more data than 6000 data and I need to make a query in phpmyadmin where I will provide a data packet to look for and this will tell me what data I am looking for do not exist...
I have the following SQL query:
SELECT DISTINCT ON (e.id) e.id, e.nombre, e.apellido, e.estado, e.documento, c.nivelado, s.nombre AS semestre, t.nombre AS tipo
FROM estudiante e
JOIN caracterizacion c ON c.estudia...
I'm trying to make a trigger in sql, but it gives me three errors that I can not solve, you can tell me if you see any error in this trigger.
CREATE OR REPLACE TRIGGER DL_3
BEFORE INSERT ON CONGRESOS FOR EACH ROW
BEGIN
SELECT AC.id_articulo...
Good afternoon, I am trying to insert records from a Cursor into a table in SQL but constructing the Insert statement in a text type variable.
Within the values I have a field of integer type, several texts and a date, apparently I am with so...
I have the following scenario:
2 Tables
Patient and Activity
The Patient table contains: DNI, First and Last name.
The Activity table contains: Patient's DNI, Activity.
Within the activity table I have repeated the DNI of the patients s...
I have the date column with the data type DATE ; I have stored data from 2018-01-01 00:00:00.0 to this date.
At the time of making a query I would like to know how I do it so that it shows me only the data of the current date....
Dear I have a winform application vb.net that uses sql server some clients use public ip and port to connect to the engine. How to cover the replication or mirror mode of the engine in case the connection fails. The idea is to have 2 Vps servers...