Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

Spelling single digits

4> 5>     CREATE PROC pr_single @chrDigit CHAR(1), @chrSd VARCHAR(6) OUTPUT 6>     AS 7>     IF @chrDigit = '1' 8>         BEGIN 9>              SELECT @chrSd = "One" 10>         RETURN 11>         END 12>     ELSE 13>     IF @chrDigit = '2' 14>         BEGIN 15>              SELECT @chrSd = "Two" 16>          RETURN 17>         END 18>     ELSE 19>     IF @chrDigit = '3' 20>         BEGIN 21>              SELECT @chrSd = "Three" 22>          RETURN 23>         END 24>     ELSE 25>     IF @chrDigit = '4' 26>         BEGIN 27>              SELECT @chrSd = "Four" 28>          RETURN 29>         END 30>     ELSE 31>     IF @chrDigit = '5' 32>         BEGIN 33>              SELECT @chrSd = "Five" 34>          RETURN 35>         END 36>     ELSE 37>     IF @chrDigit = '6' 38>         BEGIN 39>              SELECT @chrSd = "Six" 40>          RETURN 41>         END 42>     ELSE 43>     IF @chrDigit = '7' 44>         BEGIN 45>              SELECT @chrSd = "Seven" 46>          RETURN 47>         END 48>     ELSE 49>     IF @chrDigit = '8' 50>         BEGIN 51>              SELECT @chrSd = "Eight" 52>          RETURN 53>         END 54>     ELSE 55>     IF @chrDigit = '9' 56>         BEGIN 57>              SELECT @chrSd = "Nine" 58>          RETURN 59>         END 60>     ELSE 61>          SELECT @chrSd = "" 62>     GO 1> 2>     DROP PROC pr_single 3>     GO 1> 2> 3>