try this - there is a syntax error

create procedure jack

(

@departuredate datetime,

@from_place varchar(50),

@to_place varchar(50),

@travelmode nvarchar(10)

)

as

if exists('select departuredate from journey where departuredate<@departuredate')

begin

print 'Must choose greater date of departuredate'

end

else

begin

insert into journey (departuredate,from_place,to_place,travel...