blob: 27eb4f135ac442a72f207522d6e83fd063147481 (
plain)
1
2
3
4
5
6
7
8
9
|
IF COL_LENGTH('[dbo].[usuario]', 'AdmGestor') IS NOT NULL AND EXISTS(SELECT 1 FROM [dbo].[usuario] WHERE [AdmGestor] IS NULL)
BEGIN
UPDATE [dbo].[usuario] SET [AdmGestor] = '0' WHERE [AdmGestor] IS NULL;
END
IF COL_LENGTH('[dbo].[usuario]', 'Removido') IS NOT NULL AND EXISTS(SELECT 1 FROM [dbo].[usuario] WHERE [Removido] IS NULL)
BEGIN
UPDATE [dbo].[usuario] SET [Removido] = '0' WHERE [Removido] IS NULL;
END
|
