求助,写了个存储过程,调用的时候出问题了?
写了个存储过程,调用的时候,老是提示存储过程名字附近有错误,各位大侠来帮我看看
create proc MTU
@MTLastMark nvarchar(50),
@MTMarkup nvarchar(50),
@MTNumber nvarchar(120),
@ID nvarchar(120),
@Coures nvarchar(50)
as
begin
insert into MakeupTest(MTNumber,MTName,MTClass,MTCourseID,MTCourse,MTCharacter,MTTestWay,MTCredit,MTLastMark,MTMarkup,MTGeneral,MTTeacherID,MTTeacher,MTDepartment,MTInstitute,MTFailYear,MTFailTerm,MGrade,MTArea)
select MTNumber,MTName,MTClass,MTCourseID,MTCourse,MTCharacter,MTTestWay,MTCredit,MTLastMark,MTMarkup,MTGeneral,MTTeacherID,MTTeacher,MTDepartment,MTInstitute,MTFailYear,MTFailTerm,MGrade,MTArea from MakeupTest
where MTNumber= @MTNumber and MTTeacherID=@ID and MTCourse=@Coures
update MakeupTest set MTLastMark=@MTLastMark,MTMarkup=@MTMarkup
where MTNumber= @MTNumber and MTTeacherID=@ID and MTCourse=@Coures and MRetest is null
end
[解决办法]
你是怎么调用的
[解决办法]
貌似上面那种传参的写法是你们自己写的方法吧?
[解决办法]
先在查询分析器.运行存储过程看看
MTU 'test','test','test','test','test'
[解决办法]
是:成功就是C#代码问题了 ..