Stored Procedure Error

Results 1 to 2 of 2

Thread: Stored Procedure Error

  1. #1
    Rob Guest

    Default Stored Procedure Error

    CREATE PROCEDURE SP_Products @cat int<BR><BR>When I write this in my code, I get an<BR>error - expected end of statement.<BR><BR>I ahve looked at several stored examples and I do not see what I am doing wrong.<BR><BR>Thanks,<BR><BR>Rob<BR><BR>

  2. #2
    Richard A. Lowe Guest

    Default RE: Stored Procedure Error

    Well, assuming that is all there is to your code, the AS keyword followed by the SQL statement you are turning into the SPROC is required as part of the CREATE PROC command.<BR><BR>CREATE PROCEDURE SP_Products @cat int AS SELECT * FROM myProducts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts