建立存储过程提示 必须声明变量'@'

Question

--Insert into paper a record
CREATE    PROCEDURE insert_paper
                @name                         varchar(50),
                @title                            varchar(200) ,
  @FirstName1                 varchar(20),
  @LastName1                 varchar(20),
  @Position1                     varchar(20), 
                @Country1                     varchar(20),  
                @Email1                         varchar(50),
  @FirstName2                 varchar(20),
  @LastName2                 varchar(20),
  @Position2                     varchar(20), 
                @Country2                     varchar(20),  
                @Email2                         varchar(50),
   @FirstName3                 varchar(20),
  @LastName3                 varchar(20),
  @Position3                     varchar(20), 
                @Country3                     varchar(20),  
                @Email3                         varchar(50),
                @FirstName4                 varchar(20),
  @LastName4                 varchar(20),
  @Position4                     varchar(20), 
                @Country4                     varchar(20),  
                @Email4                         varchar(50),
  @FirstName5                 varchar(20),
  @LastName5                 varchar(20),
  @Position5                     varchar(20), 
                @Country5                    varchar(20),  
                @Email5                         varchar(50),
   @AddAuthor                 varchar(200),
  @ContactAuthor             varchar(10),
  @ContactEmail                varchar(50), 
                @ContactPhone               varchar(20),  
                @Keyword                        varchar(50),
   @Abstract                        varchar(500),
                @FileName                      varchar(50)

AS
BEGIN
         if not exists(select 1 from paper where name=@name and title=@title ) 
        BEGIN
insert into paper(name,title,FirstName1, LastName1,Position1,Country1,Email1,
                     FirstName2, LastName2,Position2,Country2,Email2,FirstName3, LastName3,Position3,Country3,Email3,
                     FirstName4, LastName4,Position4,Country4,Email4,FirstName5, LastName5,Position5,Country5,Email5,
                      AddAuthor,ContactAuthor,ContactEmail,ContactPhone,Keyword,Abstract,FileName)
values(@name,@title,@FirstName1,@LastName1,@Position1,@Country1,@Email1,
                     @FirstName2, @LastName2,@Position2,@Country2,@Email2,@FirstName3,@LastName3,@Position3,@Country3,@Email3,
                     @FirstName4,@ LastName4,@Position4,@Country4,@Email4,@FirstName5,@LastName5,@Position5,@Country5,@Email5,
                      @AddAuthor,@ContactAuthor,@ContactEmail,@ContactPhone,@Keyword,@Abstract,@FileName)
       END
END
GO

Answer 1

@后面多了个空格
CREATE    PROCEDURE insert_paper 
                @name                        varchar(50), 
                @title                            varchar(200) , 
  @FirstName1                varchar(20), 
  @LastName1                varchar(20), 
  @Position1                    varchar(20), 
                @Country1                    varchar(20),  
                @Email1                        varchar(50), 
  @FirstName2                varchar(20), 
  @LastName2                varchar(20), 
  @Position2                    varchar(20), 
                @Country2                    varchar(20),  
                @Email2                        varchar(50), 
  @FirstName3                varchar(20), 
  @LastName3                varchar(20), 
  @Position3                    varchar(20), 
                @Country3                    varchar(20),  
                @Email3                        varchar(50), 
                @FirstName4                varchar(20), 
  @LastName4                varchar(20), 
  @Position4                    varchar(20), 
                @Country4                    varchar(20),  
                @Email4                        varchar(50), 
  @FirstName5                varchar(20), 
  @LastName5                varchar(20), 
  @Position5                    varchar(20), 
                @Country5                    varchar(20),  
                @Email5                        varchar(50), 
  @AddAuthor                varchar(200), 
  @ContactAuthor            varchar(10), 
  @ContactEmail                varchar(50), 
                @ContactPhone              varchar(20),  
                @Keyword                        varchar(50), 
  @Abstract                        varchar(500), 
                @FileName                      varchar(50) AS 
BEGIN 
        if not exists(select 1 from paper where name=@name and title=@title ) 
        BEGIN 
insert into paper(name,title,FirstName1, LastName1,Position1,Country1,Email1, 
                    FirstName2, LastName2,Position2,Country2,Email2,FirstName3, LastName3,Position3,Country3,Email3, 
                    FirstName4, LastName4,Position4,Country4,Email4,FirstName5, LastName5,Position5,Country5,Email5, 
                      AddAuthor,ContactAuthor,ContactEmail,ContactPhone,Keyword,Abstract,FileName) 
values(@name,@title,@FirstName1,@LastName1,@Position1,@Country1,@Email1, 
                    @FirstName2, @LastName2,@Position2,@Country2,@Email2,@FirstName3,@LastName3,@Position3,@Country3,@Email3, 
                    @FirstName4,@LastName4,@Position4,@Country4,@Email4,@FirstName5,@LastName5,@Position5,@Country5,@Email5, 
                      @AddAuthor,@ContactAuthor,@ContactEmail,@ContactPhone,@Keyword,@Abstract,@FileName) 
      END 
END 
GO

Answer 2

CREATE    PROCEDURE insert_paper 
                @name                        varchar(50), 
                @title                            varchar(200) , 
  @FirstName1                varchar(20), 
  @LastName1                varchar(20), 
  @Position1                    varchar(20), 
                @Country1                    varchar(20),  
                @Email1                        varchar(50), 
  @FirstName2                varchar(20), 
  @LastName2                varchar(20), 
  @Position2                    varchar(20), 
                @Country2                    varchar(20),  
                @Email2                        varchar(50), 
  @FirstName3                varchar(20), 
  @LastName3                varchar(20), 
  @Position3                    varchar(20), 
                @Country3                    varchar(20),  
                @Email3                        varchar(50), 
                @FirstName4                varchar(20), 
  @LastName4                varchar(20), 
  @Position4                    varchar(20), 
                @Country4                    varchar(20),  
                @Email4                        varchar(50), 
  @FirstName5                varchar(20), 
  @LastName5                varchar(20), 
  @Position5                    varchar(20), 
                @Country5                    varchar(20),  
                @Email5                        varchar(50), 
  @AddAuthor                varchar(200), 
  @ContactAuthor            varchar(10), 
  @ContactEmail                varchar(50), 
                @ContactPhone              varchar(20),  
                @Keyword                        varchar(50), 
  @Abstract                        varchar(500), 
                @FileName                      varchar(50) AS 
BEGIN 
        if not exists(select 1 from paper where name=@name and title=@title ) 
        BEGIN 
insert into paper(name,title,FirstName1, LastName1,Position1,Country1,Email1, 
                    FirstName2, LastName2,Position2,Country2,Email2,FirstName3, LastName3,Position3,Country3,Email3, 
                    FirstName4, LastName4,Position4,Country4,Email4,FirstName5, LastName5,Position5,Country5,Email5, 
                      AddAuthor,ContactAuthor,ContactEmail,ContactPhone,Keyword,Abstract,FileName) 
values(@name,@title,@FirstName1,@LastName1,@Position1,@Country1,@Email1, 
                    @FirstName2, @LastName2,@Position2,@Country2,@Email2,@FirstName3,@LastName3,@Position3,@Country3,@Email3, 
                    --@FirstName4,@ LastName4,@Position4,@Country4,@Email4,@FirstName5,@LastName5,@Position5,@Country5,@Email5, 
  @FirstName4,@LastName4,@Position4,@Country4,@Email4,@FirstName5,@LastName5,@Position5,@Country5,@Email5, 
                      @AddAuthor,@ContactAuthor,@ContactEmail,@ContactPhone,@Keyword,@Abstract,@FileName) 
      END 
END 
GO

Answer 3

眼力活啊, @ LastName4 这个多个空格, 楼上说的对