Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Zmienna AS INT
- SET @Zmienna = 0
- WHILE @Zmienna < 999
- BEGIN
- PRINT @Zmienna +
- CASE
- WHEN @Zmienna/3=% THEN ' hip'
- WHEN @Zmienna/5=% THEN ' hop'
- END
- SET @Zmienna = @Zmienna + 1
- END
- ERROR: Msg 156, Level 15, State 1, Line 8
- Incorrect syntax near the keyword 'THEN'.
- Msg 102, Level 15, State 1, Line 12
- Incorrect syntax near 'END'.
- CASE
- WHEN @Zmienna % 3 = 0
- THEN ' hip'
- END
- +
- CASE
- WHEN @Zmienna % 5 = 0
- THEN ' hop'
- END
- DECLARE @Zmienna AS INT
- SET @Zmienna = 0
- WHILE @Zmienna < 999
- BEGIN
- PRINT CAST(@Zmienna as varchar) +
- CASE
- WHEN @Zmienna%3=0 THEN ' hip'
- WHEN @Zmienna%5=0 THEN ' hop'
- END
- SET @Zmienna = @Zmienna + 1
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement