BTTL7_STORE_TRIGGER - 1 2 Vi t stored-procedure Nh p vo 2 s...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 2 Vi t stored-procedure Nh p vo 2 s @s1,@s2. Xu t t ng @s1+@s2 ra tham s @tong. Cho th c thi v in gi tr c a tham s ny ki m tra d i d ng `T ng l : @tg' v i @tg =@s1+@s2. Vi t stored-procedure Nh p vo 2 s @s1,@s2. Xu t min v max c a chng ra tham s @max, @min. Cho th c thi v in gi tr c a cc tham s ny ki m tra. Thm m t c t t ng th i gian lm vi c c a nhn vin vo b ng NhanVien. Vi t store tnh t ng th i gian c a nhn vin b t k nh p vo. Vi t store xu t ra thng tin c a nhn vin c lng l n nh t cng ty. 3 4 Vi t store xu t ra lng trung bnh c a phng `Nghin c u' v tr ng phng nghin c u. Vi t store truy n v m m t nhn vin ki m tra nhn vin c t n t i khng. N u c, xu t ra HoTen nhn vin v phng c a nhn vin . N u khng t n t i, xu t thng bo "l i :" + <manv> + `Khong t n t i' Vi t trigger ki m tra nhn vin ch c lm n do phng mnh ch tr. 5 6 7 8 Vi t trigger ki m tra tr ng phng ph i l nhn vin trong phng. ...
View Full Document

This note was uploaded on 05/09/2010 for the course BACXT 9983 taught by Professor Domany during the Spring '08 term at Webster University Geneva.

Ask a homework question - tutors are online