时间戳

首页 > 解决方案 > 我创建了一个存储过程，开始出现语法错误

sql-server - 我创建了一个存储过程，开始出现语法错误

问题描述

我创建了一个存储过程，但出现了 begin 语法错误：

CREATE PROCEDURE Upload_Address
      @COM_Addresstbl 
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO COM_Address(Email, CompanyName)
        SELECT Email, CompanyName 
        FROM COM_Address
END

标签： sql-serverdatabase

解决方案

您必须指定输入的类型，例如，为 COM_Addresstbl键入nvarchar(50)

您可以使用以下代码：

CREATE PROCEDURE Upload_Address
  @COM_Addresstbl  nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;

INSERT INTO COM_Address(Email, CompanyName)
    SELECT Email, CompanyName 
    FROM COM_Address
END

推荐阅读