Samuele E. Locatelli
27 lines
574 B
SQL
27 lines
574 B
SQL
/*************************************
|
|
* 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
|