存储过程的语法错误，不知道怎么解决。

Question

Create procedure insertuserinfo
(
@username varchar(20),
@userpwd varchar(20),
@usercompany varchar (50),
@usertel char (20),
@useraddress char (30),
@useremail char (10),
@userfax char (10)
)
as
if exists
 (
select username
from userinfo
where username = @username
 )
 return 1
else
  insert userinfo ( username,userpwd,usercompany,usertel,useraddress,useremail
,userfax)
values ( @username,@userpwd,@usercompany,@usertel,@useraddress,@useremail
,@userfax)

Answer 1

Create procedure insertuserinfo
  @username varchar(20),
@userpwd varchar(20),
@usercompany varchar (50),
@usertel char (20),
@useraddress char (30),
@useremail char (10),
@userfax char (10),
 as
as
if exists
 (
select username
from userinfo
where username = @username
 )
 return 1
else
  insert userinfo ( username,userpwd,usercompany,usertel,useraddress,useremail
,userfax)
values ( @username,@userpwd,@usercompany,@usertel,@useraddress,@useremail
,@userfax)