CREATE PROCEDURE dbo.sp_scambiaObjTree ( @oldIdxObj varchar(20), @newIdxObj varchar(20) ) AS /* sposto i tree indicati */ UPDATE dbo.Obj SET idxObj = REPLACE( idxObj, @oldIdxObj, @newIdxObj ) WHERE (idxObj LIKE @oldIdxObj + '%') RETURN GO