SQL Server 2005存储过程 [英] SQL server 2005 Stored Procedure

问题描述

我正在尝试运行存储过程，但出现此错误:
消息102，级别15，状态1，过程插入未分类ICT，第7行
``@Subject''附近的语法不正确.
消息137，级别15，状态2，过程插入未分类ICT，第20行
必须声明标量变量"@Subject".

我的存储过程是:
设置ANSI_NULLS ON
设置QUOTED_IDENTIFIER ON
去
创建过程[dbo].[InsertUnclassifiedICT]
(
@Division varchar(50)，
@dateandTime datetime，
@filename varchar(50)，
@Uploadby varchar(30，
@Subject varchar(30)
)

AS
插入[dbo].[UnClassifiedFiles]
([部门/学院]
，[File_Subject]
，[文件名]
，[UploadedOn]
，[UploadedBy]
)
值
(@Division
，@ Subject
，@文件名
，@ dateandTime
，@ Uploadby

)


我在哪里犯一个简单的错误

Im trying to run a stored procedure but im getting this errors:
Msg 102, Level 15, State 1, Procedure InsertUnclassifiedICT, Line 7
Incorrect syntax near ''@Subject''.
Msg 137, Level 15, State 2, Procedure InsertUnclassifiedICT, Line 20
Must declare the scalar variable "@Subject".

And my stored procedure is:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE [dbo].[InsertUnclassifiedICT]
(
@Division varchar(50),
@dateandTime datetime,
@filename varchar(50),
@Uploadby varchar(30,
@Subject varchar(30)
)

AS
INSERT INTO [dbo].[UnClassifiedFiles]
([Division/College]
,[File_Subject]
,[File_Name]
,[UploadedOn]
,[UploadedBy]
)
VALUES
(@Division
,@Subject
,@filename
,@dateandTime
,@Uploadby

)


where am i making a simple mistake

推荐答案

@Uploadby varchar(30,

应该是:

should be:

@Uploadby varchar(30),

这篇关于SQL Server 2005存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！