
IF NOT EXISTS (SELECT NAME FROM SYS.COLUMNS C WHERE C.NAME = 'DS_VERBA' AND C.OBJECT_ID = OBJECT_ID('EST_PROD_PRECIFICACAO_VERBAS'))
	BEGIN
		ALTER TABLE EST_PROD_PRECIFICACAO_VERBAS ADD DS_VERBA VARCHAR(50)
	END

GO

UPDATE EST_PROD_PRECIFICACAO_VERBAS SET DS_VERBA = 'VERBA NR. ' + CAST(CD_VERBA AS VARCHAR)
WHERE DS_VERBA IS NULL