sql-server - 声明标量变量存储过程

Question

CREATE PROCEDURE Customer
( FName varchar(20),LName varchar(20),Birthdate datetime,Email Nvarchar(20),Houseno varchar(20),Street varchar(20),City varchar(20),Country varchar(20),Pincode int,Phno varchar(13),Mobile varchar(13),CustomerId varchar(20),Password varchar(20),ConfirmPassword varchar(20))

AS

Begin

   Insert into Registration values 
  (@FName,@LName,@Birthdate,@Email,@Houseno,@Street,@City,@Country,
   @Pincode,@Phno, @Mobile,@CustomerId,@Password,@ConfirmPassword)

End

保存时出现错误

Fname must be declare as Scalar variable

这段代码有什么问题吗？

Answer 1

您的参数声明缺少“@”符号。

create procedure Customer
@FName varchar(20),@LName varchar(20) .....