创建存储过程 end 附近有语法错误

Question

CREATE PROCEDURE getid
@divid varchar(10),
@divname int,
@topmenu int OUTPUT
AS
SELECT @topmenu=topmenu from contentshow
where name = @divid AND
age = @divname

end

[Err] 42000 - [SQL Server]'end' 附近有语法错误。

Answer 1

end和begin是成对出现的，前面少了begin。