summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL')
-rw-r--r--Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL4
1 files changed, 4 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL b/Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL
new file mode 100644
index 0000000..42d4e01
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20200831_65.SQL
@@ -0,0 +1,4 @@
+IF EXISTS(SELECT 1 FROM [dbo].[estipulante] WHERE [idempresa] IS NULL)
+BEGIN
+ UPDATE [estipulante] SET [idempresa] = 1 WHERE [idempresa] IS NULL;
+END \ No newline at end of file