SET TRANSACTION ISOLATION LEVEL READ COMMITTED
-- Modify the updatable columns
UPDATE [dbo].[StationaryMaster]
SET
[Id] = @Id, --comment this
[HistoryId] = @HistoryId,
[ServiceId] = @ServiceId,
[ServiceName] = @ServiceName,
[Status] = @Status,
[OrderId] = @OrderId,
[DoctorId] = @DoctorId,
[TransferedFromDoctorId] = @TransferedFromDoctorId,
[StationaryNumber] = @StationaryNumber,
[StationaryYear] = @StationaryYear,
[Protokol] = @Protokol,
[Date] = @Date,
[CreatedBy] = @CreatedBy,
[ModifiedBy] = @ModifiedBy,
[CreatedDate] = @CreatedDate,
[ModifiedDate] = @ModifiedDate
WHERE
[Id] = @OriginalId