Looks like you are missing a BEGIN END keyword. Pasted this from somewhere else, hope that helps :)

CREATE PROCEDURE [dbo].[INN_getPhotos]
(
@categoryID int = NULL
)
AS

IF @categoryID IS NULL
BEGIN
SELECT
photo_id,
photo_name,
photo_thumb_nam e,
photo_caption,
photo_byte_size ,
...