Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT YEAR FROM TABLE;
- IF (YEAR = 2015)
- { // do something }
- ELSE IF (YEAR = 2016)
- { // do something }
- DECLARE @CurrYear INT;
- SELECT @CurrYear = YEAR
- FROM TABLE;
- IF (@CurrYear = 2015)
- -- do something
- ELSE IF (@CurrYear = 2016)
- -- do something else
- DELIMITER //
- CREATE PROCEDURE Years ( yr INT )
- BEGIN
- IF yr = 2015 THEN
- SELECT or whatever ...;
- ELSEIF yr = 2016 THEN
- DO something else...;
- END IF;
- END //
- DELIMITER ;
Add Comment
Please, Sign In to add comment