summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL')
-rw-r--r--Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL5
1 files changed, 5 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL b/Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL
new file mode 100644
index 0000000..02b5975
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20220408_200.SQL
@@ -0,0 +1,5 @@
+IF EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 699)
+BEGIN
+ UPDATE controle SET idciaseg = 699 WHERE IDCIASEG = 791;
+ UPDATE ciaseg SET NOME = 'SEGURADORA DESATIVADA' WHERE IDCIASEG IN (791);
+END \ No newline at end of file