首页 > 数据库 >全国 地理位置-省份-市结构关系 sql脚本

全国 地理位置-省份-市结构关系 sql脚本

时间:2023-05-06 15:07:10浏览次数:43  
标签:ProvinceCity dbo 地理位置 DateTime CAST sql 0x0000A6C100004650 省份 1415

/****** Object:  Table [dbo].[ProvinceCity]    Script Date: 04/22/2017 15:27:27 ******/
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_CreatedUser]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_CreatedUser]
 END
 GO
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_CreatedDate]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_CreatedDate]
 END
 GO
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_ModifiedUser]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_ModifiedUser]
 END
 GO
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_ModifiedDate]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_ModifiedDate]
 END
 GO
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_DeletedUser]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_DeletedUser]
 END
 GO
 IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ProvinceCity_DeletedDate]') AND type = 'D')
 BEGIN
 ALTER TABLE [dbo].[ProvinceCity] DROP CONSTRAINT [DF_ProvinceCity_DeletedDate]
 END
 GO
 IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProvinceCity]') AND type in (N'U'))
 DROP TABLE [dbo].[ProvinceCity]
 GO
 /****** Object:  Table [dbo].[ProvinceCity]    Script Date: 04/22/2017 15:27:27 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProvinceCity]') AND type in (N'U'))
 BEGIN
 CREATE TABLE [dbo].[ProvinceCity](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Value] [nvarchar](50) NOT NULL,
 [Type] [int] NOT NULL,
 [ParentID] [int] NOT NULL,
 [DictionaryID] [int] NULL,
 [CreatedUser] [int] NOT NULL CONSTRAINT [DF_ProvinceCity_CreatedUser]  DEFAULT ((1415)),
 [CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_ProvinceCity_CreatedDate]  DEFAULT ('1900-01-01 00:00:00.000'),
 [ModifiedUser] [int] NOT NULL CONSTRAINT [DF_ProvinceCity_ModifiedUser]  DEFAULT ((1415)),
 [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProvinceCity_ModifiedDate]  DEFAULT ('1900-01-01 00:00:00.000'),
 [DeletedUser] [int] NOT NULL CONSTRAINT [DF_ProvinceCity_DeletedUser]  DEFAULT ((1415)),
 [DeletedDate] [datetime] NOT NULL CONSTRAINT [DF_ProvinceCity_DeletedDate]  DEFAULT ('1900-01-01 00:00:00.000'),
  CONSTRAINT [PK_ProvinceCity] PRIMARY KEY CLUSTERED 
 (
 [ID] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY]
 END
 GO
 SET IDENTITY_INSERT [dbo].[ProvinceCity] ON
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (1, N'华东地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (2, N'华北地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (4, N'东北地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (5, N'西南地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (6, N'西北地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (7, N'北京', 200, 2, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (8, N'上海', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (9, N'福建', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (10, N'安徽', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (11, N'甘肃', 200, 6, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (12, N'广东', 200, 396, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (13, N'广西', 200, 396, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (14, N'贵州', 200, 5, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (15, N'海南', 200, 396, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (16, N'河北', 200, 2, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (17, N'河南', 200, 395, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (18, N'黑龙江', 200, 4, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (19, N'湖北', 200, 395, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (20, N'湖南', 200, 395, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (21, N'吉林', 200, 4, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (22, N'江苏', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (23, N'江西', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (24, N'辽宁', 200, 4, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (25, N'内蒙古', 200, 2, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (26, N'宁夏', 200, 6, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (27, N'青海', 200, 6, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (28, N'山东', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (29, N'山西', 200, 2, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (30, N'陕西', 200, 6, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (31, N'四川', 200, 5, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (32, N'天津', 200, 2, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (33, N'西藏', 200, 5, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (34, N'新疆', 200, 6, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (35, N'云南', 200, 5, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (36, N'浙江', 200, 1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (37, N'重庆', 200, 5, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (38, N'北京', 300, 7, 1497, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (39, N'上海', 300, 8, 1497, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (40, N'安庆', 300, 10, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (41, N'蚌埠', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (42, N'亳州', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (43, N'巢湖', 300, 10, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (44, N'池州', 300, 10, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (45, N'滁州', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (46, N'阜阳', 300, 10, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (47, N'合肥', 300, 10, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (48, N'淮北', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (49, N'淮南', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (50, N'黄山', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (51, N'六安', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (52, N'马鞍山', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (53, N'宿州', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (54, N'铜陵', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (55, N'芜湖', 300, 10, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (56, N'宣城', 300, 10, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (57, N'福州', 300, 9, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (58, N'龙岩', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (59, N'南平', 300, 9, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (60, N'宁德', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (61, N'莆田', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (62, N'泉州', 300, 9, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (63, N'三明', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (64, N'厦门', 300, 9, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (65, N'漳州', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (66, N'白银', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (67, N'定西', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (68, N'甘南', 300, 11, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (69, N'嘉峪关', 300, 11, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (70, N'金昌', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (71, N'酒泉', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (72, N'兰州', 300, 11, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (73, N'临夏', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (74, N'陇南', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (75, N'平凉', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (76, N'庆阳', 300, 11, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (77, N'天水', 300, 11, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (78, N'武威', 300, 11, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (79, N'张掖', 300, 11, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (80, N'潮州', 300, 12, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (81, N'东莞', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (82, N'佛山', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (83, N'广州', 300, 12, 1497, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (84, N'河源', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (85, N'惠州', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (86, N'江门', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (87, N'揭阳', 300, 12, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (88, N'茂名', 300, 12, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (89, N'梅州', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (90, N'清远', 300, 12, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (91, N'汕头', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (92, N'汕尾', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (93, N'韶关', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (94, N'深圳', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (95, N'阳江', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (96, N'云浮', 300, 12, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (97, N'湛江', 300, 12, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (98, N'肇庆', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (99, N'中山', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (100, N'珠海', 300, 12, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (101, N'百色', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 GO
 print 'Processed 100 total records'
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (102, N'北海', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (103, N'崇左', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (104, N'防城港', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (105, N'贵港', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (106, N'桂林', 300, 13, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (107, N'河池', 300, 13, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (108, N'贺州', 300, 13, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (109, N'来宾', 300, 13, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (110, N'柳州', 300, 13, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (111, N'南宁', 300, 13, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (112, N'钦州', 300, 13, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (113, N'梧州', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (114, N'玉林', 300, 13, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (115, N'安顺', 300, 14, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (116, N'毕节', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (117, N'贵阳', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (118, N'六盘水', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (119, N'黔东南', 300, 14, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (120, N'黔南', 300, 14, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (121, N'黔西南', 300, 14, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (122, N'铜仁', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (123, N'遵义', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (124, N'海口', 300, 15, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (125, N'三亚', 300, 15, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (126, N'保定', 300, 16, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (127, N'沧州', 300, 16, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (128, N'承德', 300, 16, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (129, N'邯郸', 300, 16, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (130, N'衡水', 300, 16, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (131, N'廊坊', 300, 16, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (132, N'秦皇岛', 300, 16, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (133, N'石家庄', 300, 16, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (134, N'唐山', 300, 16, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (135, N'邢台', 300, 16, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (136, N'张家口', 300, 16, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (137, N'安阳', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (138, N'鹤壁', 300, 17, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (139, N'济源', 300, 17, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (140, N'焦作', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (141, N'开封', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (142, N'洛阳', 300, 17, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (143, N'漯河', 300, 17, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (144, N'南阳', 300, 17, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (145, N'平顶山', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (146, N'濮阳', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (147, N'三门峡', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (148, N'商丘', 300, 17, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (149, N'新乡', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (150, N'信阳', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (151, N'许昌', 300, 17, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (152, N'郑州', 300, 17, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (153, N'周口', 300, 17, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (154, N'驻马店', 300, 17, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (155, N'大庆', 300, 18, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (156, N'大兴安岭', 300, 18, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (157, N'哈尔滨', 300, 18, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (158, N'鹤岗', 300, 18, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (159, N'黑河', 300, 18, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (160, N'鸡西', 300, 18, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (161, N'佳木斯', 300, 18, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (162, N'牡丹江', 300, 18, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (163, N'七台河', 300, 18, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (164, N'齐齐哈尔', 300, 18, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (165, N'双鸭山', 300, 18, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (166, N'绥化', 300, 18, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (167, N'伊春', 300, 18, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (168, N'鄂州', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (169, N'恩施', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (170, N'黄冈', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (171, N'黄石', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (172, N'荆门', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (173, N'荆州', 300, 19, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (174, N'潜江', 300, 19, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (175, N'神农架林区', 300, 19, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (176, N'十堰', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (177, N'随州', 300, 19, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (178, N'天门', 300, 19, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (179, N'武汉', 300, 19, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (180, N'仙桃', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17F AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (181, N'咸宁', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (182, N'襄阳', 300, 19, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (183, N'孝感', 300, 19, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (184, N'宜昌', 300, 19, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (185, N'长沙', 300, 20, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (186, N'株洲', 300, 20, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (187, N'湘潭', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (188, N'衡阳', 300, 20, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (189, N'邵阳', 300, 20, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (190, N'岳阳', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (191, N'常德', 300, 20, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (192, N'张家界', 300, 20, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (193, N'益阳', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (194, N'郴州', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (195, N'永州', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (196, N'怀化', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (197, N'娄底', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (198, N'湘西', 300, 20, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (199, N'白城', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (200, N'白山', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (201, N'长春', 300, 21, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (202, N'吉林市', 300, 21, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 GO
 print 'Processed 200 total records'
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (203, N'辽源', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (204, N'四平', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (205, N'松源', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (206, N'通化', 300, 21, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (207, N'延边', 300, 21, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (208, N'常州', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (209, N'淮安', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (210, N'连云港', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (211, N'南京', 300, 22, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (212, N'南通', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (213, N'苏州', 300, 22, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (214, N'宿迁', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (215, N'泰州', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (216, N'无锡', 300, 22, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (217, N'徐州', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (218, N'盐城', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (219, N'扬州', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (220, N'镇江', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (221, N'抚州', 300, 23, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (222, N'赣州', 300, 23, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (223, N'吉安', 300, 23, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (224, N'景德镇', 300, 23, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (225, N'九江', 300, 23, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (226, N'南昌', 300, 23, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (227, N'萍乡', 300, 23, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (228, N'上饶', 300, 23, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (229, N'新余', 300, 23, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (230, N'宜春', 300, 23, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (231, N'鹰潭', 300, 23, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (232, N'鞍山', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (233, N'本溪', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (234, N'朝阳', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (235, N'大连', 300, 24, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (236, N'丹东', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (237, N'抚顺', 300, 24, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (238, N'阜新', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (239, N'葫芦岛', 300, 24, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (240, N'锦州', 300, 24, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (241, N'辽阳', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (242, N'盘锦', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (243, N'沈阳', 300, 24, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (244, N'铁岭', 300, 24, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (245, N'营口', 300, 24, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (246, N'阿拉善盟', 300, 25, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (247, N'巴彦淖尔', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (248, N'包头', 300, 25, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (249, N'赤峰', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (250, N'鄂尔多斯', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (251, N'呼和浩特', 300, 25, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (252, N'呼伦贝尔', 300, 25, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (253, N'通辽', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (254, N'乌海', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (255, N'乌兰察布', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (256, N'锡林郭勒盟', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (257, N'兴安盟', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (258, N'固原', 300, 26, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (259, N'凉山', 300, 26, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (260, N'石嘴山', 300, 26, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (261, N'吴忠', 300, 26, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (262, N'银川', 300, 26, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17E AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (263, N'中卫', 300, 26, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (264, N'果洛', 300, 27, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (265, N'海北', 300, 27, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (266, N'海东', 300, 27, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (267, N'海南', 300, 27, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (268, N'海西', 300, 27, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (269, N'黄南', 300, 27, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (270, N'西宁', 300, 27, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (271, N'玉树', 300, 27, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (272, N'滨州', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (273, N'德州', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (274, N'东营', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (275, N'菏泽', 300, 28, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (276, N'济南', 300, 28, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C17D AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (277, N'济宁', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (278, N'莱芜', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (279, N'聊城', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (280, N'临沂', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (281, N'青岛', 300, 28, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (282, N'日照', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (283, N'泰安', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (284, N'威海', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (285, N'潍坊', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (286, N'烟台', 300, 28, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (287, N'枣庄', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (288, N'淄博', 300, 28, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (289, N'长治', 300, 29, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (290, N'大同', 300, 29, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (291, N'晋城', 300, 29, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (292, N'晋中', 300, 29, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (293, N'临汾', 300, 29, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (294, N'吕梁', 300, 29, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (295, N'朔州', 300, 29, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (296, N'太原', 300, 29, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (297, N'忻州', 300, 29, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (298, N'阳泉', 300, 29, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (299, N'运城', 300, 29, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (300, N'安康', 300, 30, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (301, N'宝鸡', 300, 30, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (302, N'汉中', 300, 30, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (303, N'商洛', 300, 30, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 GO
 print 'Processed 300 total records'
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (304, N'铜川', 300, 30, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (305, N'渭南', 300, 30, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (306, N'西安', 300, 30, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (307, N'咸阳', 300, 30, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (308, N'延安', 300, 30, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (309, N'榆林', 300, 30, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (310, N'阿坝', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (311, N'巴中', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (312, N'成都', 300, 31, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (313, N'达州', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (314, N'德阳', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (315, N'甘孜', 300, 31, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (316, N'广安', 300, 31, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (317, N'广元', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (318, N'乐山', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (319, N'泸州', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (320, N'眉山', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (321, N'绵阳', 300, 31, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (322, N'内江', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (323, N'南充', 300, 31, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (324, N'攀枝花', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (325, N'遂宁', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (326, N'雅安', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (327, N'宜宾', 300, 31, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (328, N'资阳', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (329, N'自贡', 300, 31, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (330, N'天津', 300, 32, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (331, N'阿里', 300, 33, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (332, N'昌都', 300, 33, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (333, N'拉萨', 300, 33, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (334, N'林芝', 300, 33, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (335, N'那曲', 300, 33, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (336, N'日喀则', 300, 33, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (337, N'山南', 300, 33, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (338, N'阿克苏', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (339, N'阿勒泰', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (340, N'巴州', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (341, N'博州', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (342, N'昌吉州', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (343, N'哈密', 300, 34, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (344, N'和田', 300, 34, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (345, N'喀什', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C181 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (346, N'克拉玛依', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (347, N'克州', 300, 34, 1521, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A75100EFCA47 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (348, N'塔城', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (349, N'吐鲁番', 300, 34, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (350, N'乌鲁木齐', 300, 34, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (351, N'伊犁州直', 300, 34, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (352, N'西双版纳', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (353, N'保山', 300, 35, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (354, N'楚雄', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (355, N'大理', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (356, N'德宏', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (357, N'迪庆', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (358, N'红河', 300, 35, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (359, N'昆明', 300, 35, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (360, N'丽江', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (361, N'临沧', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (362, N'怒江', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (363, N'普洱', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (364, N'曲靖', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (365, N'文山', 300, 35, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (366, N'玉溪', 300, 35, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (367, N'昭通', 300, 35, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (368, N'杭州', 300, 36, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (369, N'湖州', 300, 36, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (370, N'嘉兴', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (371, N'金华', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (372, N'丽水', 300, 36, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (373, N'宁波', 300, 36, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (374, N'衢州', 300, 36, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (375, N'绍兴', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (376, N'台州', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (377, N'温州', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (378, N'舟山', 300, 36, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (379, N'重庆', 300, 37, 1498, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (380, N'延吉', 300, 21, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (381, N'满洲里', 300, 25, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (382, N'义乌', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (383, N'抚顺ss', 300, 24, 1499, 1028, CAST(0x0000A6F8010D592E AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (384, N'晋江', 300, 9, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (385, N'江阴', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (386, N'宜兴', 300, 22, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (387, N'余姚', 300, 36, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (388, N'温州', 300, 36, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B6E2D6 AS DateTime), 4106, CAST(0x0000A72800B6E2D6 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (389, N'丹寨', 300, 14, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (390, N'昆山', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (391, N'常熟', 300, 22, 1499, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (392, N'诸暨', 300, 36, 1501, 1415, CAST(0x0000A6C100004650 AS DateTime), 4106, CAST(0x0000A72800B9C182 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (393, N'太仓', 300, 22, 1501, 4106, CAST(0x0000A72701524F85 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (394, N'福清', 300, 9, 1501, 4106, CAST(0x0000A7270152F4F6 AS DateTime), 4106, CAST(0x0000A72800B9C180 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (395, N'华中地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 INSERT [dbo].[ProvinceCity] ([ID], [Value], [Type], [ParentID], [DictionaryID], [CreatedUser], [CreatedDate], [ModifiedUser], [ModifiedDate], [DeletedUser], [DeletedDate]) VALUES (396, N'华南地区', 100, -1, -1, 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000A6C100004650 AS DateTime), 1415, CAST(0x0000000000000000 AS DateTime))
 SET IDENTITY_INSERT [dbo].[ProvinceCity] OFF

 

全国 地理位置-省份-市结构关系 sql脚本_编程

标签:ProvinceCity,dbo,地理位置,DateTime,CAST,sql,0x0000A6C100004650,省份,1415
From: https://blog.51cto.com/u_16082658/6249911

相关文章

  • Web|Buuctf [NCTF2019]SQLi
    直接给出了查询语句select*fromuserswhereusername=''andpasswd=''构造语句查询,发现有过滤fuzz一下,很多参数都被过滤robots协议下发现hint.txt文件hint.txt文件,有被过滤的参数,但是没有过滤"、|和\,并且提示只要密码与admin的密码相同就可以获得flag解题思路无......
  • mysql的递归写法:部门层级
    前言详细的可以参考:https://cloud.tencent.com/developer/article/2106748这里用WITHRECURSIVE实现递归,需要MySQL8.0版本以上示例里没有加逻辑删除字段的筛选,自己加上即可,例如is_delete=0oracle的递归看我另一篇博文:表结构数据查询子节点示例WITHRECURSIVErecursionA......
  • SQL_常用查询
    <说明>SNO---学号SN----学生姓名 SheName---数据表名<说明> 【查询】select*from SheName   //取所有数据selectcount(*)from SheName //统计数据条数select SNO,SNfrom SheName//查询全体学生的学号和姓名【修改】【删除】de......
  • 从建模思路看 MySQL 和 TDengine 哪个更适合处理量化交易场景下的海量时序数据
    在“量化投资分析”场景中,系统需要从数据接口、网络上等各个地方获取证券的信息,其中往往以“实时的价格变动信息”为主要数据,然后再对这些数据进行实时的分析与存储,供盘中和盘后使用。某企业遇到的问题如下:“我们要对500个证券品种进行监控,在开盘时,每5秒会更新一次价格数据。这......
  • 使用Node.js调用Sqlite3模块写的大数据查询接口
    使用Node.js调用Sqlite3模块写的大数据查询接口constsqlite3=require('sqlite3');consthttp=require('http');consturl=require('url');constSqliteDb=async(dbFile)=>{constpri={};pri.db=newsqlite3.Database(dbFile);......
  • thinkphp使用pgsql,提示table_msg函数缺失的解决方法
    thinkphp使用pgsql,提示table_msg函数缺失的解决方法 打开navicate,打开查询,执行下面代码就可以解决:CREATEORREPLACEFUNCTIONpgsql_type(a_typevarchar)RETURNSvarcharAS$BODY$DECLAREv_typevarchar;BEGINIFa_type='int8'THENv_type:......
  • MySQL5.7 访问Information_schema.TABLES 导至内存持续增长
    在生产环境5.7.30的数据库中,部署了MYSQL监控,但是发现部署完监控后,mysqld的内存持续增长。后通过监控发现也正是监控用户占用了大量的内存。目录适用范围问题概述问题原因解决方案参考文档适用范围mysql5.7问题概述在生产环境5.7.30的数据库中,部署了MYSQL监......
  • MySQL学习之——锁(行锁、表锁、页锁、乐观锁、悲观锁等)
    锁,在现实生活中是为我们想要隐藏于外界所使用的一种工具。在计算机中,是协调多个进程或县城并发访问某一资源的一种机制。在数据库当中,除了传统的计算资源(CPU、RAM、I/O等等)的争用之外,数据也是一种供许多用户共享访问的资源。如何保证数据并发访问的一致性、有效性,是所有数据库必须......
  • MySQL为什么使用可重复读隔离级别?
    历史原因:早期MySQL的binlog日志只有statement格式,在读已提交的隔离界别下,binlog日志存在bug,会导致主从复制不一致的情况。因此默认的隔离级别使用可重复读。bug:binlog日志中记录的语句顺序和原有顺序会不一致。先删除后插入的操作,同步导从库就变成了先插入后删除的操作了。MySQL......
  • sql按分隔符裁取
    declare@strnvarchar(50);set@str='462,464,2';select@stras'字符串'selectlen(@str)as'字符长度'selectcharindex(',',@str,1)as'第一个逗号的索引值'selectLEFT(@str,charindex(',',@str,1)-1)as'第一个......