Obtain the CID domicile Location Based on the ID card number

The first version is rough

 

Http://blog.csdn.net/happyflystone/archive/2008/07/23/2700649.aspx

 

This record is detailed and forms are stored in the database.

 

Friends who need it can download and use it from my resources.

Http://download.csdn.net/user/happyflystone

 

Actually, there is no technical content

 

2. ------------------------------------
4. -- Author: flystone
6. -- Version: v1.001
8. -- Date: 2008-08-04 21:56:11
10. -- Reprinted and indicated the source
12. ------------------------------------
16. Alter function f_getinfo (@ CID varchar (18 ))
18. Returns varchar (100)
20. As
22. Begin
24. -- No legality check
26. Declare @ s varchar (100)
28. Select @ s = isnull (@ s,'') +CaseWhen demo-='Region'Then'' ElseDemo-end
30. From sfz_info
32. Where dm = left (@ CID, 2) +'123'Or dm = left (@ CID, 4) +'00'Or dm = left (@ CID, 6)
34. Order by DM
36. Return@ S
38. End
42. Go
48. Select DBO. f_getinfo ('123')
50. /*
52. Bytes ----------------------------------------------------------------------------------------------------
54. Yanqing County, Beijing
58. (The number of affected rows is 1)
60. */
64. Select DBO. f_getinfo ('123')
66. /*
68. Bytes ----------------------------------------------------------------------------------------------------
70. Xicheng District, Beijing
74. (The number of affected rows is 1)
78. */
80. Select DBO. f_getinfo ('123')
82. /*
84. Bytes ----------------------------------------------------------------------------------------------------
86. Jinzhou Miao and Dong Autonomous County, HuaiHua City, Hunan Province
90. (The number of affected rows is 1)
94. */