中国省份与城市数据SQL
本文来源：中国省份与城市数据插入 - xlx - CSDN博客 在Google找到这个，实在是爱不释手，就转过来了，很多项目都需要用到这些数据。 if exists (select * from sysobjects where id = OBJECT_ID('[province]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [province] CREATE TABLE [province] ( [id] [int] NOT NULL, [provinceID] [nvarchar] (12) NOT NULL, [province] [nvarchar] (80) NOT NULL) ALTER TABLE [province] WITH NOCHECK ADD CONSTRAINT [PK_province] PRIMARY KEY NONCLUSTERED ( [id] )INSERT [province] ([id],[provinceID],[province]) VALUES ( 1,'110000','北京市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 2,'120000','天津市') INSERT [province] ([id],[provinceID],[province]) VALUES ( 3,...