blob: 0c1d85c07cb7c5880fea6c41039bd5a5e9de5e39 (
plain)
1
2
3
4
5
6
7
8
|
IF EXISTS(SELECT 1 FROM [dbo].[item] WHERE [cancelado] IS NULL)
BEGIN
UPDATE [dbo].[item] SET [cancelado] = 0 WHERE [cancelado] IS NULL;
END
IF EXISTS(SELECT 1 FROM [dbo].[item] WHERE [sinistrado] IS NULL)
BEGIN
UPDATE [dbo].[item] SET [sinistrado] = 0 WHERE [sinistrado] IS NULL;
END
|
