CODEWITHSUNDEEP
sql-serverdatabase
krishnan
krishnan

Reputation: 33

I created a stored procedure getting begin syntax error

I created a stored procedure, but I am getting a begin syntax error:

CREATE PROCEDURE Upload_Address
      @COM_Addresstbl 
AS
BEGIN
    SET NOCOUNT ON;

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

Upvotes: 0

Views: 287

Answers (3)

B.Muthamizhselvi
B.Muthamizhselvi

Reputation: 642

CREATE PROCEDURE Upload_Address AS BEGIN SET NOCOUNT ON;

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

END

Upvotes: 0

amit ramkishor gupta
amit ramkishor gupta

Reputation: 34

You need to define table type like given below

CREATE PROCEDURE Upload_Address
      @COM_Addresstbl tabletypename readonly 

AS
BEGIN
    SET NOCOUNT ON;

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

**how to create table type **

CREATE Type tabletypename As table ( Email varchar(max), CompanyName
 varchar(max) )

Upvotes: 1

Reza Jenabi
Reza Jenabi

Reputation: 4299

You must specify the type of input, for example, type nvarchar(50) for COM_Addresstbl

You can use the following code:

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

Upvotes: 1

Related Questions