表名:ZL_Grade












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1GradeIDint40  数据ID
2Cateint40    分类ID
3ParentIDint40   0父选项ID
4GradeNamenvarchar500    分级选项名
5Gradeint40   0主键ID

简要说明:

三级字段信息表

GO
CREATE TABLE [dbo].[ZL_Grade](
[GradeID] [int] IDENTITY(1,1) NOT NULL,
[Cate] [int] NOT NULL,
[ParentID] [int] NOT NULL CONSTRAINT [DF_ZL_Grade_ParentID]  DEFAULT (0),
[GradeName] [nvarchar](50) NOT NULL,
[Grade] [int] NOT NULL CONSTRAINT [DF_ZL_Grade_Grade]  DEFAULT (0),
CONSTRAINT [PK_ZL_Grade] PRIMARY KEY CLUSTERED
(
[GradeID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Grade', @level2type=N'COLUMN', @level2name=N'GradeID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分类ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Grade', @level2type=N'COLUMN', @level2name=N'Cate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父选项ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Grade', @level2type=N'COLUMN', @level2name=N'ParentID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分级选项名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Grade', @level2type=N'COLUMN', @level2name=N'GradeName'

SET IDENTITY_INSERT [ZL_Grade] ON
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 1,1,0,N'北京市',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 2,1,0,N'上海市',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 3,1,0,N'天津市',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 4,1,0,N'重庆市',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 5,1,0,N'河北省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 6,1,0,N'江苏省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 7,1,0,N'安徽省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 8,1,1,N'海淀区',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 9,1,1,N'朝阳区',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 10,1,7,N'合肥',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 11,1,7,N'安庆',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 12,1,7,N'蚌埠',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 13,1,7,N'巢湖',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 14,1,7,N'池州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 15,1,7,N'滁州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 16,1,7,N'阜阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 17,1,7,N'淮北',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 18,1,7,N'淮南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 19,1,7,N'黄山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 20,1,7,N'六安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 21,1,7,N'马鞍山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 22,1,7,N'宿州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 23,1,7,N'铜陵',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 24,1,7,N'芜湖',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 25,1,7,N'宣城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 26,1,7,N'亳州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 27,1,5,N'石家庄',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 28,1,5,N'保定',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 29,1,5,N'沧州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 30,1,5,N'承德',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 31,1,5,N'邯郸',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 32,1,5,N'衡水',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 33,1,5,N'廊坊',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 34,1,5,N'秦皇岛',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 35,1,5,N'唐山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 36,1,5,N'邢台',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 37,1,5,N'张家口',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 38,1,6,N'南京',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 39,1,6,N'常州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 40,1,6,N'淮安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 41,1,6,N'连云港',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 42,1,6,N'南通',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 43,1,6,N'苏州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 44,1,6,N'宿迁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 45,1,6,N'泰州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 46,1,6,N'无锡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 47,1,6,N'徐州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 48,1,6,N'盐城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 49,1,6,N'扬州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 50,1,6,N'镇江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 51,1,0,N'福建省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 52,1,51,N'福州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 53,1,51,N'龙岩',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 54,1,51,N'南平',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 55,1,51,N'宁德',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 56,1,51,N'莆田',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 57,1,51,N'泉州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 58,1,51,N'三明',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 59,1,51,N'厦门',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 60,1,51,N'漳州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 61,1,0,N'甘肃省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 62,1,61,N'兰州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 63,1,61,N'白银',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 64,1,61,N'定西',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 65,1,61,N'甘南藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 66,1,61,N'嘉峪关',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 67,1,61,N'金昌',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 68,1,61,N'酒泉',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 69,1,61,N'临夏回族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 70,1,61,N'陇南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 71,1,61,N'淮南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 72,1,61,N'平凉',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 73,1,61,N'庆阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 74,1,61,N'天水',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 75,1,61,N'武威',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 76,1,61,N'张掖',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 77,1,0,N'广东省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 78,1,77,N'深圳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 79,1,77,N'潮州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 80,1,77,N'东莞',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 81,1,77,N'佛山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 82,1,77,N'广州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 83,1,77,N'河源',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 84,1,77,N'惠州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 85,1,77,N'江门',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 86,1,77,N'揭阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 87,1,77,N'茂名',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 89,1,77,N'梅州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 90,1,77,N'清远',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 91,1,77,N'汕头',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 92,1,77,N'汕尾',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 93,1,77,N'韶关',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 94,1,77,N'阳江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 95,1,77,N'云浮',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 96,1,77,N'湛江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 98,1,77,N'肇庆',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 99,1,77,N'中山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 100,1,77,N'珠海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 101,1,0,N'广西省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 102,1,101,N'南宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 103,1,101,N'百色',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 104,1,101,N'北海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 105,1,101,N'崇左',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 106,1,101,N'防城港',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 107,1,101,N'桂林',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 108,1,101,N'贵港',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 109,1,101,N'河池',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 110,1,101,N'贺州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 111,1,101,N'来宾',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 112,1,101,N'柳州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 113,1,101,N'钦州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 114,1,101,N'梧州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 115,1,101,N'玉林',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 116,1,0,N'贵州省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 117,1,116,N'贵阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 118,1,116,N'安顺',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 119,1,116,N'毕节',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 120,1,116,N'六盘水',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 121,1,116,N'黔东南苗族侗族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 122,1,116,N'黔南布依族苗族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 123,1,116,N'黔西南布依族苗族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 124,1,116,N'遵义',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 125,1,0,N'海南省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 126,1,125,N'海口',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 127,1,125,N'白沙黎族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 128,1,125,N'保亭黎族苗族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 129,1,125,N'昌江黎族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 130,1,125,N'澄迈县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 131,1,125,N'定安县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 132,1,125,N'东方',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 133,1,125,N'乐东黎族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 134,1,125,N'临高县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 135,1,125,N'陵水黎族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 136,1,125,N'琼海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 137,1,125,N'琼中黎族苗族自治县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 138,1,125,N'三亚',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 139,1,125,N'屯昌县',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 140,1,125,N'万宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 141,1,125,N'文昌',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 142,1,125,N'五指山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 143,1,125,N'儋州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 144,1,0,N'河北省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 145,1,144,N'保定',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 146,1,144,N'沧州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 147,1,144,N'承德',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 148,1,144,N'邯郸',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 149,1,144,N'衡水',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 150,1,144,N'廊坊',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 151,1,144,N'秦皇岛',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 152,1,144,N'唐山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 153,1,144,N'邢台',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 154,1,144,N'张家口',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 156,1,0,N'河南省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 157,1,156,N'郑州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 158,1,156,N'安阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 159,1,156,N'鹤壁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 160,1,156,N'济源',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 161,1,156,N'焦作',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 162,1,156,N'开封',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 163,1,156,N'洛阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 164,1,156,N'南阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 165,1,156,N'平顶山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 166,1,156,N'三门峡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 167,1,156,N'商丘',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 168,1,156,N'新乡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 169,1,156,N'信阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 170,1,156,N'许昌',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 171,1,156,N'周口',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 172,1,156,N'驻马店',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 173,1,156,N'漯河',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 174,1,156,N'濮阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 175,1,0,N'黑龙江',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 176,1,175,N'哈尔滨',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 177,1,175,N'大庆',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 178,1,175,N'大兴安岭',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 179,1,175,N'鹤岗',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 180,1,175,N'黑河',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 181,1,175,N'鸡西',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 182,1,175,N'佳木斯',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 183,1,175,N'牡丹江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 184,1,175,N'七台河',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 185,1,175,N'齐齐哈尔',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 186,1,175,N'双鸭山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 187,1,175,N'绥化',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 188,1,175,N'伊春',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 189,1,0,N'湖北省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 190,1,189,N'武汉',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 191,1,189,N'鄂州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 192,1,189,N'恩施土家族苗族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 193,1,189,N'黄冈',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 194,1,189,N'黄石',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 195,1,189,N'荆门',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 196,1,189,N'荆州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 197,1,189,N'潜江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 198,1,189,N'神农架林区',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 199,1,189,N'十堰',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 200,1,189,N'随州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 201,1,189,N'天门',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 202,1,189,N'仙桃',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 203,1,189,N'咸宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 204,1,189,N'襄樊',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 205,1,189,N'襄樊',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 206,1,189,N'宜昌',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 207,1,0,N'湖南省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 208,1,207,N'长沙',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 209,1,207,N'常德',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 210,1,207,N'郴州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 211,1,207,N'衡阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 212,1,207,N'娄底',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 213,1,207,N'邵阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 214,1,207,N'湘潭',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 215,1,207,N'湘西土家族苗族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 216,1,207,N'益阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 217,1,207,N'永州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 218,1,207,N'岳阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 219,1,207,N'张家界',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 220,1,207,N'株洲',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 221,1,0,N'吉林省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 222,1,221,N'白城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 223,1,221,N'白山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 224,1,221,N'长春',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 225,1,221,N'辽源',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 226,1,221,N'四平',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 227,1,221,N'松原',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 228,1,221,N'通化',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 229,1,221,N'延边朝鲜族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 230,1,0,N'江西省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 231,1,230,N'南昌',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 232,1,230,N'九江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 233,1,230,N'抚州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 234,1,230,N'赣州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 235,1,230,N'吉安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 236,1,230,N'景德镇',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 237,1,230,N'萍乡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 238,1,230,N'上饶',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 239,1,230,N'新余',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 240,1,230,N'宜春',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 241,1,230,N'鹰潭',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 242,1,0,N'辽宁省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 243,1,242,N'沈阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 244,1,242,N'鞍山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 245,1,242,N'本溪',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 246,1,242,N'朝阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 247,1,242,N'大连',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 248,1,242,N'丹东',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 249,1,242,N'抚顺',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 250,1,242,N'阜新',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 251,1,242,N'葫芦岛',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 252,1,242,N'锦州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 253,1,242,N'辽阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 254,1,242,N'盘锦',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 255,1,242,N'铁岭',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 256,1,242,N'营口',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 257,1,0,N'内蒙古',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 258,1,257,N'包头',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 259,1,257,N'阿拉善盟',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 261,1,257,N'巴彦淖尔盟',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 262,1,257,N'赤峰',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 263,1,257,N'鄂尔多斯',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 264,1,257,N'呼和浩特',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 265,1,257,N'呼伦贝尔',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 266,1,257,N'通辽',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 267,1,257,N'乌海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 268,1,257,N'乌兰察布盟',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 269,1,257,N'锡林郭勒盟',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 270,1,257,N'兴安盟',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 271,1,0,N'宁夏',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 272,1,271,N'银川',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 273,1,271,N'固原',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 274,1,271,N'石嘴山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 275,1,271,N'吴忠',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 276,1,0,N'青海省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 277,1,276,N'西宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 278,1,276,N'果洛藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 279,1,276,N'海北藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 280,1,276,N'海南藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 281,1,276,N'海西蒙古族藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 282,1,276,N'黄南藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 283,1,276,N'玉树藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 284,1,0,N'山东省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 285,1,284,N'济南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 286,1,284,N'滨州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 287,1,284,N'德州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 288,1,284,N'东营',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 289,1,284,N'菏泽',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 290,1,284,N'济宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 291,1,284,N'莱芜',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 292,1,284,N'聊城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 293,1,284,N'临沂',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 294,1,284,N'青岛',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 295,1,284,N'日照',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 296,1,284,N'泰安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 297,1,284,N'威海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 298,1,284,N'潍坊',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 299,1,284,N'烟台',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 300,1,284,N'枣庄',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 301,1,284,N'淄博',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 302,1,0,N'山西省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 303,1,302,N'太原',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 304,1,302,N'长治',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 305,1,302,N'大同',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 306,1,302,N'晋城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 307,1,302,N'晋中',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 308,1,302,N'临汾',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 309,1,302,N'吕梁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 310,1,302,N'朔州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 311,1,302,N'忻州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 312,1,302,N'阳泉',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 313,1,302,N'运城',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 314,1,0,N'陕西省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 315,1,314,N'西安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 316,1,314,N'安康',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 317,1,314,N'宝鸡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 318,1,314,N'汉中',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 319,1,314,N'商洛',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 320,1,314,N'铜川',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 321,1,314,N'渭南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 322,1,314,N'咸阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 323,1,314,N'延安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 324,1,314,N'榆林',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 325,1,2,N'上海',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 326,1,0,N'四川省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 327,1,326,N'成都',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 328,1,326,N'阿坝藏族羌族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 329,1,326,N'巴中',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 330,1,326,N'达州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 331,1,326,N'德阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 332,1,326,N'甘孜藏族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 333,1,326,N'广安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 334,1,326,N'广元',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 335,1,326,N'乐山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 336,1,326,N'凉山彝族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 337,1,326,N'眉山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 338,1,326,N'绵阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 339,1,326,N'南充',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 340,1,326,N'内江',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 341,1,326,N'攀枝花',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 342,1,326,N'遂宁',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 343,1,326,N'雅安',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 344,1,326,N'宜宾',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 345,1,326,N'资阳',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 346,1,326,N'自贡',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 347,1,326,N'泸州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 348,1,3,N'天津',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 349,1,0,N'西藏',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 350,1,349,N'拉萨',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 351,1,349,N'阿里',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 352,1,349,N'昌都',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 353,1,349,N'林芝',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 354,1,349,N'那曲',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 355,1,349,N'日喀则',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 356,1,349,N'山南',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 357,1,0,N'新疆',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 358,1,357,N'乌鲁木齐',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 359,1,357,N'阿克苏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 361,1,357,N'巴音郭楞蒙古自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 362,1,357,N'博尔塔拉蒙古自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 363,1,357,N'昌吉回族自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 364,1,357,N'哈密',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 365,1,357,N'和田',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 366,1,357,N'喀什',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 367,1,357,N'克拉玛依',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 368,1,357,N'克孜勒苏柯尔克孜自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 369,1,357,N'石河子',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 370,1,357,N'图木舒克',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 371,1,357,N'吐鲁番',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 372,1,357,N'五家渠',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 373,1,357,N'伊犁哈萨克自治州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 374,1,0,N'浙江省',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 375,1,374,N'杭州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 376,1,374,N'湖州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 377,1,374,N'嘉兴',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 378,1,374,N'金华',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 379,1,374,N'丽水',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 380,1,374,N'宁波',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 381,1,374,N'绍兴',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 382,1,374,N'台州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 383,1,374,N'温州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 384,1,374,N'舟山',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 385,1,374,N'衢州',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 386,1,4,N'重庆',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 387,1,1,N'丰台区',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 388,1,1,N'通州区',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 389,2,0,N'电脑/网络',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 390,2,0,N'生活',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 391,2,0,N'医疗健康',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 392,2,0,N'体育/运动',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 393,2,0,N'电子数码',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 394,2,0,N'商业/理财',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 395,2,0,N'教育/科学',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 396,2,0,N'社会民生',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 397,2,0,N'文化/艺术',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 398,2,0,N'游戏',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 399,2,0,N'娱乐休闲',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 400,2,0,N'烦恼',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 401,2,0,N'资源共享',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 402,2,389,N'电脑装机',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 403,2,389,N'硬件',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 404,2,389,N'软件',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 405,2,389,N'反病毒',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 406,2,389,N'互联网',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 407,2,390,N'服装/首饰',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 408,2,390,N'美容/塑身',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 409,2,390,N'美食/烹饪',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 410,2,390,N'购车养车',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 411,2,390,N'交通出行',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 412,2,390,N'购物',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 413,2,391,N'内科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 414,2,391,N'外科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 415,2,391,N'妇产科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 416,2,391,N'儿科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 417,2,391,N'五官科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 418,2,391,N'人体常识',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 419,2,392,N'足球',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 420,2,392,N'篮球',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 421,2,392,N'健身',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 422,2,392,N'赛车/F1',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 423,2,392,N'运动用品',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 424,2,392,N'武术搏击',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 425,2,393,N'手机购买',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 426,2,393,N'手机使用',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 427,2,393,N'照相机/摄像机',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 428,2,393,N'MP4/MP3',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 429,2,394,N'股票',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 430,2,394,N'财务税务',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 431,2,394,N'银行业务',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 432,2,394,N'创业投资',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 433,2,394,N'贸易',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 434,2,394,N'个人理财',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 435,2,395,N'升学入学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 436,2,395,N'学习帮助',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 437,2,395,N'职业教育',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 438,2,395,N'英语考试',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 439,2,395,N'出国/留学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 440,2,395,N'理工学科',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 441,2,396,N'法律',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 442,2,396,N'公务办理',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 443,2,396,N'时事政治',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 444,2,396,N'宗教',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 445,2,396,N'求职就业',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 446,2,397,N'文学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 447,2,397,N'历史话题',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 448,2,397,N'民俗传统',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 449,2,397,N'器乐/声乐',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 450,2,397,N'舞蹈',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 451,2,397,N'书画美术',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 452,2,398,N'网络游戏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 453,2,398,N'单机游戏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 454,2,398,N'电视游戏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 455,2,398,N'手机游戏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 456,2,398,N'小游戏',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 457,2,399,N'音乐',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 458,2,399,N'电影',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 459,2,399,N'电视',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 460,2,399,N'动漫',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 461,2,399,N'星座/运势',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 462,2,399,N'宠物',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 463,2,400,N'恋爱',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 464,2,400,N'夫妻',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 465,2,400,N'家庭关系',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 466,2,400,N'校园生活',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 467,2,400,N'情感情绪',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 468,2,400,N'交友技巧',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 469,2,401,N'视频共享',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 470,2,401,N'音频/歌曲共享',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 471,2,401,N'软件共享',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 472,2,401,N'文档/报告共享',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 474,3,0,N'人物',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 475,3,0,N'文化',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 476,3,0,N'技术',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 477,3,0,N'历史',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 478,3,0,N'艺术',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 479,3,0,N'生活',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 480,3,0,N'地理',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 481,3,0,N'社会',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 482,3,0,N'体育',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 483,3,0,N'自然',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 484,3,0,N'科学',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 485,3,0,N'经济',1)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 486,3,474,N'自然科学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 487,3,474,N'人文领域',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 488,3,474,N'社会科学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 489,3,474,N'文学领域',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 490,3,474,N'军事领域',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 491,3,474,N'艺术领域',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 492,3,474,N'体育领域',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 493,3,474,N'虚拟人物',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 494,3,486,N'科学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 495,3,486,N'医学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 496,3,486,N'数学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 497,3,486,N'物理学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 498,3,486,N'化学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 499,3,486,N'农学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 500,3,486,N'农业学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 501,3,486,N'古生物学家',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 502,3,486,N'医师',3)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 503,3,475,N'文学',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 504,3,475,N'中华文化',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 505,3,475,N'文物古迹',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 506,3,475,N'学派',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 507,3,475,N'宗教',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 508,3,475,N'民俗',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 509,3,475,N'语种',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 510,3,475,N'网络文化',2)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 520,6,0,N'一年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 521,6,0,N'二年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 522,6,0,N'三年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 523,6,0,N'四年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 524,6,0,N'五年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 525,6,0,N'六年级',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 526,6,0,N'初一',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 527,6,0,N'初二',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 528,6,0,N'初三',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 529,6,0,N'高一',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 530,6,0,N'高二',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 531,6,0,N'高三',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 532,7,0,N'人教版',0)
INSERT [ZL_Grade] ([GradeID],[Cate],[ParentID],[GradeName],[Grade]) VALUES ( 533,7,0,N'15黄冈版',0)
SET IDENTITY_INSERT [ZL_Grade] OFF

--注意:将清空全表数据

detele from ZL_Grade

--注意:将删除整个表

drop table ZL_Grade

--注意:清空且复位表ID序列为初始值

TRUNCATE table ZL_Grade