summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL
diff options
context:
space:
mode:
Diffstat (limited to 'Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL')
-rw-r--r--Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL5
1 files changed, 5 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL b/Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL
new file mode 100644
index 0000000..e4b21af
--- /dev/null
+++ b/Codemerx/Gestor.Application.Migration.Files.20210722_169.SQL
@@ -0,0 +1,5 @@
+DECLARE @sql NVARCHAR(MAX) = N'ALTER TABLE cliente ADD MalaDireta BIT'
+IF COL_LENGTH('[dbo].[cliente]', 'MalaDireta') IS NULL
+BEGIN
+ exec sp_executesql @sql
+END \ No newline at end of file