blob: ff1baf50d31390378469a78c8b09dcf3e1814e5e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sinistroauto' ) AND COL_LENGTH('[dbo].[sinistroauto]', 'culpado') IS NOT NULL
BEGIN
UPDATE [dbo].[sinistroauto]
SET culpado = 2
WHERE culpado is null OR culpado = 1;
UPDATE [dbo].[sinistroauto]
SET culpado = 1
WHERE culpado = 0;
UPDATE [dbo].[sinistroauto]
SET culpado = 0
WHERE culpado = 2;
END
|
