省城县市区区域数据 xml、sql

USE [DBCT_Dev] GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[S_Province]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[S_Province]( [ProvinceID] [bigint] IDENTITY(1,1) NOT NULL, [ProvinceName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DateCreated] [datetime] NULL, [DateUpdated] [datetime] NULL, CONSTRAINT [PK_S_Province] PRIMARY KEY CLUSTERED ( [ProvinceID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END GO SET IDENTITY_INSERT [dbo].[S_Province] ON INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (1, N'北京市', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (2, N'天津市', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (3, N'河北省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (4, N'山西省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (5, N'内蒙古自治区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (6, N'辽宁省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (7, N'吉林省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (8, N'黑龙江省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (9, N'上海市', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (10, N'江苏省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (11, N'浙江省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (12, N'安徽省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (13, N'福建省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (14, N'江西省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (15, N'山东省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (16, N'河南省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (17, N'湖北省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (18, N'湖南省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (19, N'广东省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (20, N'广西壮族自治区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (21, N'海南省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (22, N'重庆市', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (23, N'四川省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (24, N'贵州省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (25, N'云南省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (26, N'西藏自治区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (27, N'陕西省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (28, N'甘肃省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (29, N'青海省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (30, N'宁夏回族自治区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (31, N'新疆维吾尔自治区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (32, N'香港特别行政区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (33, N'澳门特别行政区', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) INSERT [dbo].[S_Province] ([ProvinceID], [ProvinceName], [DateCreated], [DateUpdated]) VALUES (34, N'台湾省', CAST(0x00009A28014555BE AS DateTime), CAST(0x00009A28014555BE AS DateTime)) SET IDENTITY_INSERT [dbo].[S_Province] OFF /****** Object: Table [dbo].[S_City] Script Date: 04/27/2008 20:54:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[S_City]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[S_City]( [CityID] [bigint] IDENTITY(1,1) NOT NULL, [CityName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ZipCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ProvinceID] [bigint] NULL, [DateCreated] [datetime] NULL, [DateUpdated] [datetime] NULL, CONSTRAINT [PK_S_City] PRIMARY KEY CLUSTERED ( [CityID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END GO SET IDENTITY_INSERT [dbo].[S_City] ON INSERT [dbo].[S_City] ([CityID], [CityName], [ZipCode], [ProvinceID], [DateCreated], [DateUpdated]) VALUES (1, N'北京市', N'100000