blob: 99220f541793a6d7c4f15e99c137e10df5c4dc8f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
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
|
