View difference between Paste ID: rKwQ46Km and s1nF6g9m

 --2
 create table byvali_studenti
   (
    id_student int,
    cislo_studenta int primary key not null,
    jmeno varchar (30),
    prijmeni varchar (50),
    adresa varchar (50),
    obec varchar (30),
    psc numeric (5),
    telefon numeric (9),
    datum date
   )
 
 create trigger smazano on student
 for delete
 as
  begin
 insert into byvali_studenti (id_student,cislo_studenta,jmeno,prijmeni,adresa,obec,psc,telefon,datum)
  select id_student,cislo_studenta,jmeno,prijmeni,adresa,obec,psc,telefon, GETDATE() from deleted
 end
 
 --3
 begin tran TZ1
 delete from hodnoceni where cislo_studenta=4567
 delete from student where cislo_studenta=4567
 select * from byvali_studenti
 select * from student
 --commit tran TZ1
 rollback tran TZ1
 
 
 --4
 create procedure kurz
 @nazev varchar(50)
 as
 begin
 select k.nazev,t.semestr,t.ucebna,t.den,t.cas,p.cislo_predchozi from kurs k,terminy t,predpoklady p
 where @nazev=k.nazev
 end
 
 execute kurz 'Databázové systémy'
 
 
 --5
 create procedure vnorena
 @cislo_lektora int
 as
 begin
   if (@cislo_lektora is  null)
     begin
      print 'Student nebyl z daneho kurzu hodnocen'
     end
   else
    begin
    select jmeno+' '+prijmeni as 'Jméno učitele',telefon from lektor
     where @cislo_lektora=cislo_lektora
    end
 end
 
 create procedure ucitel
 @cislo_studenta int,   --je to navesene na cislo_studenta a ne id_studenta, cislo_studenta je primarni klic, s id_studenta by to bylo o podminku delsi
 @cislo_kurzu varchar(4),
 @cislo_lektora int output
 as
 begin
  set @cislo_lektora= (select t.cislo_lektora from terminy t, hodnoceni h
                         where @cislo_kurzu=t.cislo_kursu and @cislo_studenta=h.cislo_studenta
                         and h.id_terminu=t.id_terminu)
 execute vnorena @cislo_lektora
 end
 
 declare @cislo_lektora int
 execute ucitel 4965,'X100',@cislo_lektora output
 
 --6
 declare Kurzor cursor for
  select s.jmeno,s.prijmeni,t.den,t.ucebna from student s,terminy t,hodnoceni h
  where s.cislo_studenta=h.cislo_studenta and h.id_terminu=t.id_terminu
  declare
    @jmeno varchar(30),
    @prijmeni varchar(30),
    @den varchar(10),
    @ucebna varchar(5)
   open Kurzor
   fetch Kurzor into @jmeno,@prijmeni,@den,@ucebna
    while @@fetch_status=0
     begin
      print @jmeno+' '+@prijmeni+' - '+@den+' - Učebna: '+@ucebna
      fetch Kurzor into @jmeno,@prijmeni,@den,@ucebna
     end
   close Kurzor
   deallocate Kurzor