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 mode) values(@depaturedate,@from_place,
@to_place ,
@travelmode,
)
end
go