summaryrefslogtreecommitdiff
path: root/Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL')
-rw-r--r--Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL5
1 files changed, 5 insertions, 0 deletions
diff --git a/Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL b/Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL
new file mode 100644
index 0000000..7324289
--- /dev/null
+++ b/Decompiler/Gestor.Application.Migration.Files.20220502_205-.SQL
@@ -0,0 +1,5 @@
+IF EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [idramo] = 52)
+BEGIN
+ UPDATE controle SET IDRAMO = 4 WHERE IDRAMO = 52;
+ DELETE FROM ramo WHERE IDRAMO = 52;
+END \ No newline at end of file