Codemerx/Gestor.Application.Migration.Files.20201230_94.SQL


1
2
3
4
5

IF EXISTS(SELECT 1 FROM [dbo].[cliente] WHERE sexo = 'F' OR sexo = 'M')
BEGIN
	UPDATE [dbo].[cliente] SET sexo=1 WHERE sexo = 'F';
	UPDATE [dbo].[cliente] SET sexo=0 WHERE sexo = 'M';
END