Samuele E. Locatelli
24 lines
541 B
SQL
24 lines
541 B
SQL
/*************************************
|
|
* STORED PROCEDURE stp_ImpRis_insert
|
|
*
|
|
* insert record impiego risorse
|
|
*
|
|
* mod : 17/03/2015
|
|
* aut : S.E. Locatelli
|
|
**************************************/
|
|
CREATE PROCEDURE stp_ImpRis_insert
|
|
(
|
|
@CodRisorsa NVARCHAR(10)
|
|
, @numIntMtz INT
|
|
, @QtaRisorsa DECIMAL(18, 6)
|
|
, @CostoUnit DECIMAL(18, 6)
|
|
, @Note NVARCHAR(MAX)
|
|
)
|
|
AS
|
|
|
|
INSERT INTO ImpiegoRisorse(CodRisorsa, numIntMtz, QtaRisorsa, CostoUnit, Note)
|
|
VALUES (@CodRisorsa, @numIntMtz, @QtaRisorsa, @CostoUnit, @Note)
|
|
|
|
|
|
RETURN
|