Samuele Locatelli
34 lines
704 B
Transact-SQL
34 lines
704 B
Transact-SQL
/***************************************
|
|
* STORED stp_celle_updateQuery
|
|
*
|
|
* aggiorna cella indicata
|
|
*
|
|
* Steamware, S.E.L.
|
|
* mod: 2010.07.16
|
|
*
|
|
****************************************/
|
|
create PROCEDURE [dbo].[stp_celle_updateQuery]
|
|
(
|
|
@Original_IdxCella INT,
|
|
@CodCS VARCHAR(2),
|
|
@CodCella VARCHAR(50),
|
|
@IdxTipoCella INT,
|
|
@Descrizione VARCHAR(50),
|
|
@Attiva BIT,
|
|
@Piena BIT,
|
|
@IdxBlocco INT,
|
|
@X INT,
|
|
@Y INT,
|
|
@Z INT
|
|
)
|
|
AS
|
|
|
|
|
|
UPDATE Celle
|
|
SET [CodCS] = @CodCS, [CodCella] = @CodCella, [IdxTipoCella] = @IdxTipoCella, [Descrizione] = @Descrizione,
|
|
[Attiva] = @Attiva, [Piena] = @Piena, [IdxBlocco] = @IdxBlocco, [X] = @X, [Y] = @Y, [Z] = @Z
|
|
WHERE ([IdxCella] = @Original_IdxCella)
|
|
|
|
|
|
RETURN
|