Spelling single digits. : Utility Procedure « Procedure Function « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Procedure Function
3. Utility Procedure

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>