Update data in sql

Question

Update data in sql

Navigation

#1 by (1 votes)

0

I have the following code, I would like to know how to modify it to make an update to the data that I consult from the id_rol_tercero table, the table I want to update is called rol_por_tercero,

use NameDatabase
SELECT  
    rol_por_tercero.id_tercero, 
    rol_por_tercero.id_rol_tercero
FROM    
    rolprovedor 
INNER JOIN      
    rol_por_tercero 
ON  
    rolprovedor.id_tercero = rol_por_tercero.id_tercero

sql sql-server-2012

asked by Andrex_11 26.01.2018 в 15:13

source

1 answer

My images do not appear in laravel To know the last day of the month between 2 AngularJS dates

score 1 · Accepted Answer

For MS SQL Server it would be:

UPDATE ROL
SET ROL.id_rol_tercero = 4 -- Valor a actualizar
FROM rol_por_tercero ROL
    INNER JOIN roprovedor PVR on PVR.id_tercero = ROL.id_tercero
--Si tienes un filtro adicional usa un WHERE aqui con la condicion