summaryrefslogtreecommitdiff
path: root/Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL')
-rw-r--r--Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL24
1 files changed, 24 insertions, 0 deletions
diff --git a/Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL b/Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL
new file mode 100644
index 0000000..ddd6f15
--- /dev/null
+++ b/Decompiler/Gestor.Application.Migration.Files.20220329_196.SQL
@@ -0,0 +1,24 @@
+IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 894)
+BEGIN
+ INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (894, N'OPERADORA UNICENTRAL DE PLANOS DE SAUDE LTDA', '02.888.465/0001-56', 0, 2);
+END
+--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 895)
+--BEGIN
+-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (895, N'BEPLUS SAUDE CORRETORA DE SEGUROS LTDA', '12.402.717/0001-49', 0, 2);
+--END
+--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 896)
+--BEGIN
+-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (896, N'HEBROM CORRETORA DE SEGUROS LTDA', '08.179.439/0001-35', 0, 2);
+--END
+--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 898)
+--BEGIN
+-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (898, N'RAMED 4YOU CORRETORA DE SEGUROS LTDA', '36.454.780/0001-97', 0, 2);
+--END
+--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 899)
+--BEGIN
+-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (899, N'DINASTY CORRETORA DE SEGUROS UNIPESSOAL LTDA', '40.514.996/0001-78', 0, 2);
+--END
+--IF NOT EXISTS (SELECT 1 FROM [dbo].[ciaseg] WHERE [idciaseg] = 900)
+--BEGIN
+-- INSERT INTO [dbo].[ciaseg] ([IDCIASEG],[NOME],[CGCCPF],[ATIVO],[TOLERANCIA]) VALUES (900, N'RAMED MIX CORRETORA DE SEGUROS LTDA', '12.346.564.0001-60', 0, 2);
+--END \ No newline at end of file