提示：INSERT 失败，因为下列 SET 选项的设置不正确: 'ARITHABORT'。

2004-07-08 10:23:26 383 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

我在执行网页insert时显示INSERT 失败，因为下列 SET 选项的设置不正确: 'ARITHABORT'。但是我把要执行得语句write之后在sql查询分析器里能执行。
其中执行得表中有一字段（song）得公式为(convert(varchar,[seqid]) + '.vod')，seqid为其中一字段，网页执行得sql语句为insert into ylwjx_song(seqid,name,singer) values(" & seq & ",'"& songname &"','"& singer &"')

...全文

使用Keras检测图片中是否包含圣诞老人项目说明为了进行Keras对于图像处理的学习而参考[点击此处进入学习]其中包括详细的优化过程(https://www.pyimagesearch.com/2017/12/11/image-classification-with-keras-and-deep-learning/) 数据集来源数据集包括两部分，一部分是来自Google下抓取的图片461张（包含圣诞老人），【教你如何利用Google... 阅读详情

ffly

.NET社区 62,272 成员 668,968 内容

+ 关注 + 加入社区

切换为时间正序

vzxq 2004-07-08

打赏
举报

实在不行改成存储过程吧。

ffly 2004-07-08

打赏
举报

脚本发错了，这个才是
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cj_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cj_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dj]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[examcontent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[examcontent]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kc_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kc_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kq_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kq_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kql_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kql_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ks_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ks_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[msglist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[msglist]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[remark_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[remark_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sadmin_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sadmin_name]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[school_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[school_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[schoolhandsetbbs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[schoolhandsetbbs]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stepctrl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[stepctrl]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[student_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[submit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[submit]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[teacher_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[teacher_list]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[userinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[userinfo]
GO

CREATE TABLE [dbo].[cj_list] (
[class_id] [int] NOT NULL ,
[student_id] [int] NOT NULL ,
[examcontent_id] [int] NOT NULL ,
[fs] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[ks_time] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[class_list] (
[class_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[class_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[school_id] [int] NOT NULL ,
[isuse] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dj] (
[dj_id] [int] NOT NULL ,
[dj_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dj_address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[examcontent] (
[examcontent_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[exam_name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ks_id] [int] NOT NULL ,
[examsubject] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b_date] [smalldatetime] NULL ,
[e_date] [smalldatetime] NULL ,
[class_id] [bigint] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[kc_list] (
[kc_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[class_id] [int] NULL ,
[xq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[kc_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[teacher_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[kq_list] (
[kqL_id] [bigint] NOT NULL ,
[student_id] [int] NULL ,
[kq_time] [datetime] NULL ,
[kq_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[kq_id] [bigint] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[kql_list] (
[kql_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[kql_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ks_list] (
[ks_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[ks_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[msglist] (
[msgid] [int] IDENTITY (1, 1) NOT NULL ,
[Fphone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Tphone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Fuserid] [int] NULL ,
[Tuserid] [int] NULL ,
[content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sendtime] [datetime] NULL ,
[Fid] [int] NULL ,
[isstudent] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[remark_list] (
[remart_id] [bigint] IDENTITY (1, 1) NOT NULL ,
[class_id] [int] NOT NULL ,
[teacher_id] [bigint] NOT NULL ,
[content] [varchar] (140) COLLATE Chinese_PRC_CI_AS NULL ,
[datetime] [datetime] NULL ,
[student_id] [bigint] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sadmin_name] (
[sadmin_id] [int] IDENTITY (1, 1) NOT NULL ,
[school_id] [int] NOT NULL ,
[sadmin_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sex] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ffly 2004-07-08

打赏
举报

这是那个表的sql脚本
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[movie_list]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[movie_list]
GO

CREATE TABLE [dbo].[movie_list] (
[movie_id] [int] IDENTITY (1, 1) NOT NULL ,
[movie_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[movie_time] [smalldatetime] NULL ,
[tickes] [int] NOT NULL ,
[serial] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[movie_list] WITH NOCHECK ADD
CONSTRAINT [DF_move_list_move_time] DEFAULT (getdate()) FOR [movie_time],
CONSTRAINT [DF_movie_list_tickes] DEFAULT (0) FOR [tickes]
GO

ffly 2004-07-08

打赏
举报

seqid为整型的

liangshaojun 2004-07-08

打赏
举报

insert into ylwjx_song(seqid,name,singer) values('" & seq & "','"& songname &"','"& singer &"')

ffly 2004-07-08

打赏
举报

括起来没用

brightheroes 2004-07-08

打赏
举报

insert into ylwjx_song(seqid,name,singer) values(" & seq & ",'"& songname &"','"& singer &"')
--->
insert into ylwjx_song(seqid,[name],singer) values(" & seq & ",'"& songname &"','"& singer &"')
把name括起来

提示：INSERT 失败，因为下列 SET 选项的设置不正确: 'ARITHABORT'。

相关推荐