c#之尝试将 sql 数据导入 visual studio web 表单数据库

我正在尝试导入以下数据:

    INSERT INTO shifts (shift_id, shift_facility_id, shift_user_id, shift_start_time, shift_replacement, shift_request_replacement) VALUES 
(1, 57, '1', '2017-05-19 00:00:00.000000', NULL, NULL), 
(2, 57, '1', '2017-05-19 12:00:00.000000', NULL, NULL), 
(3, 57, '1', '2017-05-20 00:00:00.000000', NULL, NULL), 
(4, 57, '1', '2017-05-20 12:00:00.000000', NULL, NULL), 
(5, 57, '2', '2017-05-21 00:00:00.000000', NULL, NULL), 
(62, 59, '6', '2017-05-19 00:00:00.000000', NULL, NULL), 
(64, 60, '4', '2017-05-19 00:00:00.000000', NULL, NULL); 

在以下数据库中:

(本地数据库)\MSSQLLocalDB

CREATE TABLE shifts ( 
 
shift_id int NOT NULL,  
  shift_facility_id int NOT NULL, 
  shift_user_id varchar(64) NOT NULL, 
  shift_start_time datetime NOT NULL, 
  shift_replacement varchar(64) DEFAULT NULL, 
  shift_request_replacement varchar(65) DEFAULT NULL 
)  

但是我一直报错

Conversion failed when converting date and/or time from character string. 

我试图从查询本身中删除每个 '(它修复了一次以前的问题)但这次没有成功。

错误是由这些部分产生的:

'2017-05-20 12:00:00.000000' 

有谁知道如何使这个 SQL 查询可执行？

请您参考如下方法:

只需这样做:

 INSERT INTO shifts (shift_id, shift_facility_id, shift_user_id, shift_start_time, shift_replacement, shift_request_replacement)  
 VALUES 
            (1, 57, '1', '2017-05-19 00:00:00', NULL, NULL), 
            (2, 57, '1', '2017-05-19 12:00:00', NULL, NULL), 
            (3, 57, '1', '2017-05-20 00:00:00', NULL, NULL), 
            (4, 57, '1', '2017-05-20 12:00:00', NULL, NULL), 
            (5, 57, '2', '2017-05-21 00:00:00', NULL, NULL), 
            (62, 59, '6', '2017-05-19 00:00:00', NULL, NULL) 
            (64, 60, '4', '2017-05-19 00:00:00', NULL, NULL); 

你有一个 datetime 字段，你不需要比它更精确，所以直到分钟你应该没问题。