Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER VIEW view_PodaciEdukatoraPredmeta
- AS
- SELECT E.Ime+' '+E.Prezime AS 'Ime i prezime', P.Naziv, P.Oznaka, P.ECTS, EP.BrojSati
- FROM Edukatori AS E JOIN EdukatoriPredmeti AS EP
- ON E.EdukatorID=EP.EdukatorID JOIN Predmeti AS P
- ON P.PredmetID=EP.PredmetID
- CREATE PROCEDURE usp_EdukatoriPredmeti_VratiNastavnoOsobljeNaPredmetu
- (
- @Naziv nvarchar(25)
- )
- AS
- BEGIN
- SELECT *
- FROM view_PodaciEdukatoraPredmeta AS PEP
- WHERE PEP.Naziv=@Naziv
- END
- EXEC usp_EdukatoriPredmeti_VratiNastavnoOsobljeNaPredmetu 'Programiranje2'
- ALTER PROCEDURE usp_EdukatoriPredmeti_VratiNastavnoOsobljeNaPredmetu
- (
- @Naziv nvarchar(25),
- @Edukator nvarchar(50)
- )
- AS
- BEGIN
- SELECT *
- FROM view_PodaciEdukatoraPredmeta AS PEP
- WHERE PEP.Naziv=@Naziv OR (PEP.Ime+' '+PEP.Prezime=@Edukator)
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement