/************************************* * STORED PROCEDURE stp_ATR_update * * aggiorna record anagrafica tipo risorse * * mod : 17/03/2015 * aut : S.E. Locatelli **************************************/ CREATE PROCEDURE stp_ATR_update ( @Original_CodRisorsa NVARCHAR(10), @CodRisorsa NVARCHAR(10), @UM NVARCHAR(10), @DescrRisorsa NVARCHAR(50), @Valuta NVARCHAR(5) ) AS UPDATE AnagTipoRisorsa SET CodRisorsa = @CodRisorsa , UM = @UM , DescrRisorsa = @DescrRisorsa , Valuta = @Valuta WHERE CodRisorsa = @Original_CodRisorsa RETURN