summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20200914_66.SQL
blob: 9dac06693f72cc3c1cc79cf6b4c8dc328b349471 (plain)
1
2
3
4
IF COL_LENGTH('[dbo].[usuario]', 'inativo') IS NOT NULL
BEGIN
  UPDATE usuario SET INATIVO = 0 WHERE INATIVO IS NULL OR LTRIM(RTRIM(INATIVO)) = '';
END