SQL SERVER2005存储过程解析
向SingleProblem表中指定的单选题进行修改:
CREATE PROCEDURE [dbo].[proc_singleproblemmodify]
(@CourseID [int],
@Title [varchar](1000),
@AnswerA [varchar](500),
@AnswerB [varchar](500),
@AnswerC [varchar](500),
@AnswerD [varchar](500),
@Answer [varchar](2))
AS update [数据库名].[dbo].[singleproblem]
set [CourseID] = @CourseID,//题号
[Title] =@Title, //题目
[AnswerA] = @AnswerA,//答案A
[AnswerB] = @AnswerB,
[AnswerC] = @AnswerC,
[AnswerD] = @AnswerD,
[Answer] = @Answer//答案
WHERE ([ID] = @ID)
上面的是SQL SERVER2005存储过程,[CourseID]加中括号是什么意思?@AnswerA前面的@是什么意思?
请问转换成SQL SERVER2000存储过程是什么?