Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select es.estud_nombre1,estud_ape2,es.estud_documento,gr.grup_nom,ps.materias,hr.hora_inicio,hr.hora_fin
- from estudiantes es
- inner join grupos gr
- on gr.id = es.grupos_id
- inner join pensum ps
- on gr.id = ps.grupos_id
- inner join horarios hr
- on hr.id = ps.horarios_id
- where gr.grup_nom='grupo 3'
- order by es.estud_nombre1
- EXEC xp_cmdshell
- 'bcp "SELECT * FROM Personas" queryout "C:test_data_personas.txt" -T -c -t,'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement