写了个存储过程，调用的时候，老是提示存储过程名字附近有错误，各位大侠来帮我看看
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 [email protected] and [email protected]
update MakeupTest set [email protected],[email protected]
where MTNumber= @MTNumber and [email protected] and [email protected] and MRetest is null
end
------解决方案--------------------
你是怎么调用的
------解决方案--------------------
貌似上面那种传参的写法是你们自己写的方法吧？
------解决方案--------------------
先在查询分析器.运行存储过程看看
- SQL code
MTU 'test','test','test','test','test'
------解决方案--------------------
是:成功就是C#代码问题了 ..