Samuele E. Locatelli
29 lines
622 B
SQL
29 lines
622 B
SQL
/*************************************
|
|
* STORED PROCEDURE stp_ImpRis_update
|
|
*
|
|
* update record impiego risorse
|
|
*
|
|
* mod : 17/03/2015
|
|
* aut : S.E. Locatelli
|
|
**************************************/
|
|
CREATE PROCEDURE stp_ImpRis_update
|
|
(
|
|
@Original_idxImpiego INT
|
|
, @CodRisorsa NVARCHAR(10)
|
|
, @numIntMtz INT
|
|
, @QtaRisorsa DECIMAL(18, 6)
|
|
, @CostoUnit DECIMAL(18, 6)
|
|
, @Note NVARCHAR(MAX)
|
|
)
|
|
AS
|
|
|
|
UPDATE ImpiegoRisorse
|
|
SET CodRisorsa = @CodRisorsa
|
|
, numIntMtz = @numIntMtz
|
|
, QtaRisorsa = @QtaRisorsa
|
|
, CostoUnit = @CostoUnit
|
|
, Note = @Note
|
|
WHERE idxImpiego = @Original_idxImpiego
|
|
|
|
RETURN
|