Problem creating a procedure

• thesequel

  Grasshopper

  Points: 21

  More actions

  March 13, 2012 at 10:07 pm

  #265767

  hello,

  I am new to SQL and trying to create a procedure in SQl Server 2008 R2.

  This is the code that I copy and pasted from the training book.

  CREATE PROCEDURE GET_CD_ARTISTS ( )

  SELECT cd.CD_TITLE, a.ARTIST_NAME

  FROM COMPACT_DISCS cd, ARTIST_CDS ac, ARTISTS a

  WHERE cd.COMPACT_DISC_ID = ac.COMPACT_DISC_ID

  AND ac.ARTIST_ID = a.ARTIST_ID;

  However, I get the error around the brackets in the first line:

  Msg 102, Level 15, State 1, Procedure GET_CD_ARTISTS, Line 1

  Incorrect syntax near ')'.

  Any solution to the problem?

  Thanks.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 13, 2012 at 10:50 pm

  #1458981

  Try dropping the parens.

• sanjay.kumar-853392

  Valued Member

  Points: 58

  More actions

  March 13, 2012 at 10:57 pm

  #1458982

  The correct Syntax is

  CREATE PROCEDURE GET_CD_ARTISTS

  AS

  SELECT cd.CD_TITLE, a.ARTIST_NAME

  FROM COMPACT_DISCS cd, ARTIST_CDS ac, ARTISTS a

  WHERE cd.COMPACT_DISC_ID = ac.COMPACT_DISC_ID

  AND ac.ARTIST_ID = a.ARTIST_ID;

  Regards,

  SAN -INDIA