DELETE FROM [dbo].[Trip] WHERE (([trip_no] = @Original_trip_no) AND ([ID_comp] = @Original_ID_comp) AND ([plane] = @Original_plane) AND ([town_from] = @Original_town_from) AND ([town_to] = @Original_town_to) AND ([time_out] = @Original_time_out) AND ([time_in] = @Original_time_in)) INSERT INTO [dbo].[Trip] ([trip_no], [ID_comp], [plane], [town_from], [town_to], [time_out], [time_in]) VALUES (@trip_no, @ID_comp, @plane, @town_from, @town_to, @time_out, @time_in); SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM Trip WHERE (trip_no = @trip_no) SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM dbo.Trip UPDATE [dbo].[Trip] SET [trip_no] = @trip_no, [ID_comp] = @ID_comp, [plane] = @plane, [town_from] = @town_from, [town_to] = @town_to, [time_out] = @time_out, [time_in] = @time_in WHERE (([trip_no] = @Original_trip_no) AND ([ID_comp] = @Original_ID_comp) AND ([plane] = @Original_plane) AND ([town_from] = @Original_town_from) AND ([town_to] = @Original_town_to) AND ([time_out] = @Original_time_out) AND ([time_in] = @Original_time_in)); SELECT trip_no, ID_comp, plane, town_from, town_to, time_out, time_in FROM Trip WHERE (trip_no = @trip_no)