SQL Server中ASCII和字符对应关系的方法

来源：互联网发布：2016年网络零售交易额编辑：程序博客网时间：2024/04/20 01:49

有时侯可能找一些字符的ASCII码, 为了方便就全找出来了.

SQL Server中执行以下语句即可:

DECLARE @position int, @string char(8)

SET @position = 1

WHILE @position <= 128
BEGIN
   SET @string = char(@position)
   print cast(@position as char(5))+'---   '+ @string
   SET @position = @position + 1
END
GO

结果:

1    ---
2    ---
3    ---
4    ---
5    ---
6    ---
7    ---
8    ---
9    ---
10   ---

11   ---
12   ---
13   ---

14   ---
15   ---
16   ---
17   ---
18   ---
19   ---
20   ---
21   ---
22   ---
23   ---
24   ---
25   ---
26   ---
27   ---
28   ---
29   ---
30   ---
31   ---
32   ---
33   ---   !
34   ---   "
35   ---   #
36   ---   $
37   ---   %
38   ---   &
39   ---   '
40   ---   (
41   ---   )
42   ---   *
43   ---   +
44   ---   ,
45   ---   -
46   ---   .
47   ---   /
48   ---   0
49   ---   1
50   ---   2
51   ---   3
52   ---   4
53   ---   5
54   ---   6
55   ---   7
56   ---   8
57   ---   9
58   ---   :
59   ---   ;
60   ---   <
61   ---   =
62   ---   >
63   ---   ?
64   ---   @
65   ---   A
66   ---   B
67   ---   C
68   ---   D
69   ---   E
70   ---   F
71   ---   G
72   ---   H
73   ---   I
74   ---   J
75   ---   K
76   ---   L
77   ---   M
78   ---   N
79   ---   O
80   ---   P
81   ---   Q
82   ---   R
83   ---   S
84   ---   T
85   ---   U
86   ---   V
87   ---   W
88   ---   X
89   ---   Y
90   ---   Z
91   ---   [
92   ---   /
93   ---   ]
94   ---   ^
95   ---   _
96   ---   `
97   ---   a
98   ---   b
99   ---   c
100 ---   d
101 ---   e
102 ---   f
103 ---   g
104 ---   h
105 ---   i
106 ---   j
107 ---   k
108 ---   l
109 ---   m
110 ---   n
111 ---   o
112 ---   p
113 ---   q
114 ---   r
115 ---   s
116 ---   t
117 ---   u
118 ---   v
119 ---   w
120 ---   x
121 ---   y
122 ---   z
123 ---   {
124 ---   |
125 ---   }
126 ---   ~
127 ---
128 ---   €