Stored Procedure, 'incorrect syntax error'

Posted by jacksonSD on Stack Overflow See other posts from Stack Overflow or by jacksonSD
Published on 2013-11-06T03:47:47Z Indexed on 2013/11/06 3:53 UTC
Read the original article Hit count: 142

Filed under:
|
|

Attempting to figure out sp's, and I'm getting this error: "Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'Procedure'." the error seems to be on the if, but I can drop other existing tables with stored procedures the exact same way so I'm not clear on why this isn't working. can anyone shed some light?

Begin
Set nocount on 
Begin Try

    Create Procedure uspRecycle
    as
        if OBJECT_ID('Recycle') is not null
            Drop Table Recycle

        create table Recycle
            (RecycleID integer
                constraint PK_integer primary key,
            RecycleType nchar(10) not null,
            RecycleDescription nvarchar(100) null)

            insert into Recycle
                (RecycleID,RecycleType,RecycleDescription)
            values ('1','Compost','Product is compostable, instructions included in packaging')
            insert into Recycle
                (RecycleID,RecycleType,RecycleDescription)
            values ('2','Return','Product is returnable to company for 100% reuse')
            insert into Recycle
                (RecycleID,RecycleType,RecycleDescription)
            values ('3','Scrap','Product is returnable and will be reclaimed and reprocessed')
            insert into Recycle
                (RecycleID,RecycleType,RecycleDescription)
            values ('4','None','Product is not recycleable')



End Try

Begin Catch
  DECLARE @ErrMsg nvarchar(4000);
  SELECT @ErrMsg = ERROR_MESSAGE();
  Throw 50001, @ErrMsg, 1;
End Catch

-- checking to see if table exists and is loaded:
If (Select count(*) from Recycle) >1 
    begin
        Print 'Recycle table created and loaded '; Print getdate()
    End
set nocount off 
End

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server