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

ffly 2004-07-08 10:23:26
我在执行网页insert时显示INSERT 失败,因为下列 SET 选项的设置不正确: 'ARITHABORT'。 但是我把要执行得语句write之后在sql查询分析器里能执行。
其中执行得表中有一字段(song)得公式为(convert(varchar,[seqid]) + '.vod'),seqid为其中一字段,网页执行得sql语句为insert into ylwjx_song(seqid,name,singer) values(" & seq & ",'"& songname &"','"& singer &"')
...全文
307 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
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括起来

62,025

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见,支持健康理性的辩论和互动,反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧