Advertisement
jzgeorge

sql cambio de docente

Nov 30th, 2018
326
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE esq_ceac_planclase.tbl_syllabus
  2.    SET id_personal = 111037,
  3.    contribucion_perfil = 'B',
  4.    nombre_docente = 'OTERO DIEGUEZ ANTONIO MANUEL'
  5. WHERE idregistro in (11422, 11926, 11151);
  6.  
  7. UPDATE esq_ceac_planclase.tbl_plc_planclase
  8.    SET  iddocente=111037
  9.   WHERE idsyllabus in (11422, 11926, 11151);
  10.  
  11. UPDATE esq_ceac_planclase.tbl_plc_clases_docente
  12.    SET id_personal=111037
  13.   WHERE id_plan_clase in (8597,8647,8778,9117,8783);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement