70 lines
1.6 KiB
Transact-SQL
70 lines
1.6 KiB
Transact-SQL
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
/*
|
|
Rollback della patch prenotazione plist.
|
|
|
|
Ripristina dal backup salvato da:
|
|
- apply_plist_reservation_patch.sql
|
|
|
|
Oggetti ripristinati:
|
|
- dbo.XMag_ViewPackingList
|
|
- dbo.sp_xExePackingListPallet
|
|
- dbo.sp_xExePackingListPalletPrenota
|
|
- dbo.sp_ControllaPrenotazionePackingListPalletNew
|
|
|
|
La tabella dbo.PickingListReservation NON viene rimossa:
|
|
- può restare nel DB
|
|
- il codice legacy non la usa
|
|
*/
|
|
|
|
DECLARE @BackupTag varchar(64) = 'plist_reservation_fix_alpha2';
|
|
DECLARE @Sql nvarchar(max);
|
|
|
|
IF OBJECT_ID(N'dbo.WarehouseObjectBackup', N'U') IS NULL
|
|
BEGIN
|
|
RAISERROR('dbo.WarehouseObjectBackup non esiste. Impossibile fare rollback.', 16, 1);
|
|
RETURN;
|
|
END;
|
|
|
|
IF NOT EXISTS (
|
|
SELECT 1
|
|
FROM dbo.WarehouseObjectBackup
|
|
WHERE BackupTag = @BackupTag
|
|
)
|
|
BEGIN
|
|
RAISERROR('Backup tag %s non trovato. Impossibile fare rollback.', 16, 1, @BackupTag);
|
|
RETURN;
|
|
END;
|
|
|
|
SELECT @Sql = Definition
|
|
FROM dbo.WarehouseObjectBackup
|
|
WHERE BackupTag = @BackupTag
|
|
AND ObjectName = N'dbo.XMag_ViewPackingList';
|
|
|
|
IF @Sql IS NOT NULL EXEC(@Sql);
|
|
|
|
SELECT @Sql = Definition
|
|
FROM dbo.WarehouseObjectBackup
|
|
WHERE BackupTag = @BackupTag
|
|
AND ObjectName = N'dbo.sp_xExePackingListPallet';
|
|
|
|
IF @Sql IS NOT NULL EXEC(@Sql);
|
|
|
|
SELECT @Sql = Definition
|
|
FROM dbo.WarehouseObjectBackup
|
|
WHERE BackupTag = @BackupTag
|
|
AND ObjectName = N'dbo.sp_xExePackingListPalletPrenota';
|
|
|
|
IF @Sql IS NOT NULL EXEC(@Sql);
|
|
|
|
SELECT @Sql = Definition
|
|
FROM dbo.WarehouseObjectBackup
|
|
WHERE BackupTag = @BackupTag
|
|
AND ObjectName = N'dbo.sp_ControllaPrenotazionePackingListPalletNew';
|
|
|
|
IF @Sql IS NOT NULL EXEC(@Sql);
|
|
|