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