sql存储过程

create PROCEDURE proc_Sales
(
@Lastname VARCHAR (50),
@firstname VARCHAR(50),
@price FLOAT,
@city VARCHAR(50),
@address VARCHAR(50)
)
AS
BEGIN
INSERT into persons(lastname,firstname,price,city,address) 
VALUES(@lastname,@firstname,@price,@city,@address);
END

执行：

execute proc_Sales ......--依次传入参数