【旅客列车时刻里程数据库（2023-02-25，SQL格式）】

CREATE TABLE [dbo].[train_data]( [_index] [int] NULL, [train_no] [nvarchar](50) NULL, [stop_name] [nvarchar](50) NULL, [mile] [int] NULL, [arrive_time] [nvarchar](50) NULL, [start_time] [nvarchar](50) NULL, [add_day] [int] NULL) ON [PRIMARY] GO insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 0, '宝鸡', 0, '16:04', '16:04', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 1, '蔡家坡', 43, '16:34', '16:36', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 2, '杨陵', 88, '17:05', '17:08', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 3, '咸阳西', 143, '17:45', '17:47', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 4, '西安', 171, '18:12', '18:26', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 5, '渭南', 227, '19:06', '19:08', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 6, '潼关', 306, '20:10', '20:12', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 7, '灵宝', 383, '21:14', '21:16', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 8, '三门峡', 436, '21:58', '22:00', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 9, '洛阳', 558, '23:44', '00:12', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 10, '郑州', 682, '01:53', '02:14', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 11, '开封', 754, '03:00', '03:02', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 12, '商丘', 885, '04:26', '04:43', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 13, '砀山', 948, '05:26', '05:30', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 14, '徐州', 1031, '06:50', '06:56', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 15, '新沂', 1140, '08:13', '08:17', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 16, '连云港', 1221, '09:15', '09:19', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1148', 17, '连云港东', 1241, '09:51', '09:51', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 0, '连云港东', 0, '16:15', '16:15', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 1, '连云港', 20, '16:43', '16:46', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 2, '东海县', 60, '17:12', '17:31', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 3, '新沂', 101, '18:02', '18:08', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 4, '徐州', 210, '19:41', '19:54', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 5, '黄口', 259, '20:27', '20:29', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 6, '砀山', 293, '20:54', '21:00', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 7, '虞城县', 336, '21:34', '21:38', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 8, '商丘', 356, '21:53', '22:05', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 9, '兰考', 444, '23:01', '23:04', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 10, '开封', 487, '23:35', '23:38', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 11, '郑州', 559, '00:24', '00:44', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 12, '洛阳', 683, '02:18', '02:22', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 13, '孟塬', 894, '06:27', '06:29', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 14, '渭南', 954, '07:17', '07:19', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 15, '西安', 1010, '08:07', '08:16', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 16, '咸阳', 1033, '08:35', '08:43', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 17, '武功', 1083, '09:14', '09:23', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 18, '杨陵', 1095, '09:33', '09:35', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1150', 19, '宝鸡', 1183, '10:37', '10:37', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 0, '上海', 0, '20:08', '20:08', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 1, '苏州', 84, '21:10', '21:19', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 2, '无锡', 126, '21:47', '21:50', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 3, '常州', 165, '22:17', '22:20', 0) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 4, '南京', 301, '00:23', '00:29', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 5, '滁州北', 358, '01:07', '01:17', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 6, '蚌埠', 485, '02:41', '02:47', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 7, '徐州', 649, '04:39', '04:53', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 8, '枣庄西', 717, '05:45', '05:47', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 9, '滕州', 751, '06:09', '06:11', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 10, '邹城', 791, '06:40', '06:42', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 11, '兖州', 812, '06:57', '06:59', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 12, '磁窑', 861, '07:32', '07:34', 1) insert into train_data(train_no, _index, stop_name, mile, arrive_time, start_time, add_day) values('1228', 13, '泰山', 895, '07:58', '08:02', 1) insert into train_data(train_no, _index, stop