IF EXISTS(SELECT 1 FROM [dbo].[cliente] WHERE [idempresa] IS NULL) BEGIN UPDATE [dbo].[cliente] SET [idempresa] = 1 WHERE [idempresa] IS NULL; END IF EXISTS(SELECT 1 FROM [dbo].[parcela] WHERE [idempresa] IS NULL) BEGIN UPDATE [dbo].[parcela] SET [idempresa] = 1 WHERE [idempresa] IS NULL; END IF EXISTS(SELECT 1 FROM [dbo].[parcela] WHERE [idempresa] IS NULL) BEGIN UPDATE [dbo].[parcela] SET [idempresa] = 1 WHERE [idempresa] IS NULL; END