SQLSERVER中执行以下SQL报错:
INSERT [dbo].[g_DJyiqi] ([g_ID], [g_username], [g_Date], [g_DriverID], [g_DJDate], [g_yqDJDjiedi], [g_yqDJDkaiguanji], [g_yqDJDxianshiping], [g_yqDJDgongzuoqu], [g_yqDJDfuzhu], [g_yqDJDjiaozhun], [g_yqDJDyure], [g_yqDJWzhongdian], [g_yqDJWjike], [g_yqDJWxianshiping], [g_yqDJWfuzhu], [g_yqDJWqingjie], [g_yqDJWjilu], [g_yqDJMzhongdian], [g_yqDJMqingjie], [g_yqDJMzuse], [g_yqDJMchuandong], [g_yqDJMdianyuan], [g_yqDJMdianlu], [g_zdhFailReason]) VALUES (88718, N'admin1 ', N'day ', N'XHY-0003-GC', N'2023-10-08', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', NULL)
消息 544,级别 16,状态 1,服务器 WIN-PMKCL7U3LHP,第 5 行
当 IDENTITY_INSERT 设置为 OFF 时,不能为表 'dbo.g_DJyiqi' 中的标识列插入显
式值。
原因:sqlserver的自增列,如果插入的话就会报以上的错.
解决方法:按以下方法执行将不报错:
set IDENTITY_INSERT [dbo].[g_DJyiqi]on
INSERT [dbo].[g_DJyiqi] ([g_ID], [g_username], [g_Date], [g_DriverID], [g_DJDate], [g_yqDJDjiedi], [g_yqDJDkaiguanji], [g_yqDJDxianshiping], [g_yqDJDgongzuoqu], [g_yqDJDfuzhu], [g_yqDJDjiaozhun], [g_yqDJDyure], [g_yqDJWzhongdian], [g_yqDJWjike], [g_yqDJWxianshiping], [g_yqDJWfuzhu], [g_yqDJWqingjie], [g_yqDJWjilu], [g_yqDJMzhongdian], [g_yqDJMqingjie], [g_yqDJMzuse], [g_yqDJMchuandong], [g_yqDJMdianyuan], [g_yqDJMdianlu], [g_zdhFailReason]) VALUES (88718, N'admin1 ', N'day ', N'XHY-0003-GC', N'2023-10-08', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'1 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', N'0 ', NULL)
SET IDENTITY_INSERT [dbo].[g_DJyiqi] OFF