| Version 5 (modified by , 7 days ago) ( diff ) |
|---|
Functions, procedures and triggers
Функции
Certification Expiry
- Параметри: DaysUntil (број на денови од моменталниот датум до датумот на истекување)
- Резултат: табела со колони - EmployeeID, Name, Surname, Active, !CertificationID, CertificationType, AirplaneModel, ExpirationDate, DaysUntilExpiration, IsExpired
Со оваа фунцкија се излистуваат сите сертификати и медицински прегледи на вработените кои истекуваат за DaysUntil.
Attachments (16)
- CertificationExpiry.sql (814 bytes ) - added by 7 days ago.
- ConnectingFlights.sql (1.5 KB ) - added by 7 days ago.
- FindAlternativeFlights.sql (2.2 KB ) - added by 7 days ago.
- GetFlightCrew.sql (1004 bytes ) - added by 7 days ago.
- AssignSeat.sql (1.8 KB ) - added by 7 days ago.
- Board.sql (1.4 KB ) - added by 7 days ago.
- CancelFlight.sql (1.2 KB ) - added by 7 days ago.
- ChangeFlightStatus.sql (853 bytes ) - added by 7 days ago.
- CheckInTicket.sql (2.4 KB ) - added by 7 days ago.
- PurchaseTicket.sql (3.6 KB ) - added by 7 days ago.
- AwardMilePoints.sql (1.1 KB ) - added by 7 days ago.
- IncreaseFinalPriceBaggage.sql (455 bytes ) - added by 7 days ago.
- SetSeatReserved.sql (355 bytes ) - added by 7 days ago.
- UpdateAirplaneFlightHours.sql (632 bytes ) - added by 7 days ago.
- UpdateLastMaintenance.sql (609 bytes ) - added by 7 days ago.
- AddBaggage.sql (1.4 KB ) - added by 5 days ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.
