Guest User

Untitled

a guest
Oct 24th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SELECT YEAR FROM TABLE;
  2. IF (YEAR = 2015)
  3. { // do something }
  4. ELSE IF (YEAR = 2016)
  5. { // do something }
  6.  
  7. DECLARE @CurrYear INT;
  8.  
  9. SELECT @CurrYear = YEAR
  10. FROM TABLE;
  11.  
  12. IF (@CurrYear = 2015)
  13. -- do something
  14. ELSE IF (@CurrYear = 2016)
  15. -- do something else
  16.  
  17. DELIMITER //
  18. CREATE PROCEDURE Years ( yr INT )
  19. BEGIN
  20. IF yr = 2015 THEN
  21. SELECT or whatever ...;
  22. ELSEIF yr = 2016 THEN
  23. DO something else...;
  24. END IF;
  25. END //
  26. DELIMITER ;
Add Comment
Please, Sign In to add comment