Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. DECLARE @Zmienna AS INT
  2. SET @Zmienna = 0
  3.  
  4. WHILE @Zmienna < 999
  5. BEGIN
  6. PRINT @Zmienna +
  7. CASE
  8. WHEN @Zmienna/3=% THEN ' hip'
  9. WHEN @Zmienna/5=% THEN ' hop'
  10. END
  11. SET @Zmienna = @Zmienna + 1
  12. END
  13.  
  14. ERROR: Msg 156, Level 15, State 1, Line 8
  15. Incorrect syntax near the keyword 'THEN'.
  16. Msg 102, Level 15, State 1, Line 12
  17. Incorrect syntax near 'END'.
  18.  
  19. CASE
  20. WHEN @Zmienna % 3 = 0
  21. THEN ' hip'
  22. END
  23. +
  24. CASE
  25. WHEN @Zmienna % 5 = 0
  26. THEN ' hop'
  27. END
  28.  
  29. DECLARE @Zmienna AS INT
  30. SET @Zmienna = 0
  31.  
  32. WHILE @Zmienna < 999
  33. BEGIN
  34. PRINT CAST(@Zmienna as varchar) +
  35. CASE
  36. WHEN @Zmienna%3=0 THEN ' hip'
  37. WHEN @Zmienna%5=0 THEN ' hop'
  38. END
  39. SET @Zmienna = @Zmienna + 1
  40. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement