存储过程创建失败！！！

Question

大家帮我看一下：
CREATE PROCEDURE select_teacher_2 
@ TeacherName varchar(200) 
AS 
SELECT * FROM teacher  where TEACHERNAME = @TeacherName
说第二行varchar附近有语法错误！
数据库名称是TeacherMangerSys，里面有张teacher表，是怎么回事呀？
里面有个TeacherName字段，类型varchar(200)

Answer 1

CREATE PROCEDURE select_teacher_2 
 @TeacherName varchar(200) 
AS 
SELECT * FROM teacher  where TEACHERNAME = @TeacherName

Answer 2

@ TeacherName varchar(200)---@和名字之间不能有空格

Answer 3

@TeacherName varchar(200) //............
AS 
SELECT * FROM teacher  where TEACHERNAME = @TeacherName

Answer 4

CREATE PROCEDURE select_teacher_2
@TeacherName varchar(200)
AS
SELECT * FROM teacher where TEACHERNAME = @TeacherName

Answer 5

CREATE PROCEDURE select_teacher_2 
@TeacherName varchar(200) 
AS 
SELECT * FROM teacher  where TEACHERNAME = @TeacherName
@后面的空格去掉