求助,写了个存储过程,调用的时候出问题了?
写了个存储过程,调用的时候,老是提示存储过程名字附近有错误,各位大侠来帮我看看
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
------解决方案--------------------你是怎么调用的
------解决方案--------------------貌似上面那种传参的写法是你们自己写的方法吧?
------解决方案--------------------先在查询分析器.运行存储过程看看
SQL code
MTU 'test','test','test','test','test'
------解决方案--------------------
是:成功就是C#代码问题了 ..