Good morning classmates I need to know how I can identify when the first record of a relationship is created, I have 2 related tables the main table has idclase primary key and the second table with its foreign key idclase and primary key id tes...
I would like to request your support to select some items from my datagridview when selecting an option in the checkedlistbox. Example if I select option 2 only the last 3 options must be marked on the grid. I only achieve that everything is sel...
Is it possible to make a query, which created columns automatically according to the data, regardless of the condition?
Let me explain:
I have a table of surveys, another table that contains the questions that are made by surveys and other...
When I connect to the database of Sql Server 2008 R2 with the autenticación de windows from the Data Adapter Wizard of Report Design in the same eclipse - java , I get the following error:
These are the da...
I have the following query in Laravel through query builder:
$objective_risk = DB::table('objective_risk')
->join('objectives','objectives.id','=','objective_risk.objective_id')
->join('risks','risks.id','=','...
I have the following error when executing a script:
Arithmetic overflow error converting numeric to data type numeric.
I have a table called TBL_ADENDA_ACH in a development database and I run the following script:
SELECT * FRO...
Hi chic @ s I have this script:
<?php
session_start();
include_once "conexion.php";
function verificar_login($user,$password,&$result) {
$sql = "SELECT * FROM usuarios WHERE usuario = '$user' and password = '$password'";
$r...
I have these tables in my database to assign roles to my users:
tbl usuario
id
nombre
contraseña
correo
fk_rol
--------------------
tbl rol
id_rol
nombre
descripcion
--------------------
tbl pagina...
I've been searching the internet but I do not find anything like it. In a table in SQL I have three columns, names, paternal surname and maternal surname, how can I join the columns in a new one, all three in one with their spaces? I have the fo...
I am trying to do a procedure stored in SQL for a restaurant sales system that when adding a dish to a sale check if there is stock of the ingredients available and return a response 1 if there is or 0 if there is not.
ALTER proc [dbo].[ch...