日期:2014-05-18  浏览次数:20481 次

求助,写了个存储过程,调用的时候出问题了?
写了个存储过程,调用的时候,老是提示存储过程名字附近有错误,各位大侠来帮我看看
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#代码问题了 ..