blob: ecd8381868cc4007db34fc42a540fcc183c3b63a (
plain)
1
2
3
4
|
IF EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usuario' AND COLUMN_NAME = 'identif')
BEGIN
UPDATE usuario SET identif = CONCAT(identif, '_REM') WHERE Removido = 1 and (identif NOT LIKE '%_REM' AND identif NOT LIKE '%_REMOVIDO');
END
|
