diff options
Diffstat (limited to 'Codemerx/Gestor.Application.Migration.Files.20220502_205 .SQL')
| -rw-r--r-- | Codemerx/Gestor.Application.Migration.Files.20220502_205 .SQL | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Application.Migration.Files.20220502_205 .SQL b/Codemerx/Gestor.Application.Migration.Files.20220502_205 .SQL new file mode 100644 index 0000000..7324289 --- /dev/null +++ b/Codemerx/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 |