19 lines
No EOL
707 B
Transact-SQL
19 lines
No EOL
707 B
Transact-SQL
IF (COL_LENGTH('T_NEMKOTOTTMUNKAIDO', 'C_TULAJDONOSID_BAK') IS NULL)
|
|
BEGIN
|
|
ALTER TABLE [T_NEMKOTOTTMUNKAIDO] ADD [C_TULAJDONOSID_BAK] INT NULL;
|
|
END
|
|
GO
|
|
|
|
IF (COL_LENGTH('T_ORARENDIORA', 'C_ORATULAJDONOSID_BAK') IS NULL)
|
|
BEGIN
|
|
ALTER TABLE [T_ORARENDIORA] ADD [C_ORATULAJDONOSID_BAK] INT NULL;
|
|
END
|
|
GO
|
|
|
|
DISABLE TRIGGER tr_AsyncAuditNEMKOTOTTMUNKAIDO ON T_NEMKOTOTTMUNKAIDO;
|
|
UPDATE T_NEMKOTOTTMUNKAIDO SET [C_TULAJDONOSID_BAK] = C_TULAJDONOSID;
|
|
ENABLE TRIGGER tr_AsyncAuditNEMKOTOTTMUNKAIDO ON T_NEMKOTOTTMUNKAIDO;
|
|
|
|
DISABLE TRIGGER tr_AsyncAuditORARENDIORA ON T_ORARENDIORA;
|
|
UPDATE T_ORARENDIORA SET C_ORATULAJDONOSID_BAK = C_ORATULAJDONOSID;
|
|
ENABLE TRIGGER tr_AsyncAuditORARENDIORA ON T_ORARENDIORA; |