i m trying to update a table which is a shorter version of my original table. What i have is the following:
UPDATE (SELECT * FROM bookings_tbl
where ACCOUNT LIKE 'RENTA%' AND PART_TYPE ='HARDWARE')
SET PART_TYPE= 'EQUIPO' WHERE PART_TYPE='HARDWARE';
don't know if it s possible, but i would like to have what is stated as HARDWARE in that small table saying EQUIPO. i m using micros SQL Server Mgmt Studio
Aucun commentaire:
Enregistrer un commentaire