Begin 附近的语法无效

Question

CREATE PROCEDURE InsertSummary

    (
    @symbol nvarchar(50),
    @openValue nvarchar(50),
    @closeValue nvarchar(50),
    @highvalue nvarchar(50),
    @lowvalue varchar(50),
    @currentValue nvarchar(50),
    @change nvarchar(50),
    @volume nvarchar(50)
    )

BEGIN

INSERT INTO [MarketSummary]
     (
        [Symbol],
        [Open],
        [Close],
        [High],
        [Low],
        [Current],
        [Change],
        [Volume]
    ) VALUES 
    ( 
        @symbol,
        @openValue,
        @closeValue,
        @highValue,
        @lowValue,
        @currentValue,
        @change,
        @volume
)
;

END

Answer 1

如果您查看CREATE PROCEDURE的语法您会看到它在 BEGIN 之前需要 AS。