Samuele E. Locatelli
26 lines
461 B
SQL
26 lines
461 B
SQL
/*************************************
|
|
* STORED PROCEDURE stp_StatoMag_delete
|
|
*
|
|
* elimina record magazzino (item + giacenza...)
|
|
*
|
|
* mod : 19/11/2015
|
|
* aut : S.E. Locatelli
|
|
**************************************/
|
|
CREATE PROCEDURE stp_StatoMag_delete
|
|
(
|
|
@Original_idxItem INT = 0
|
|
)
|
|
AS
|
|
|
|
|
|
BEGIN tran
|
|
|
|
DELETE FROM MagRic
|
|
WHERE idxItem = @Original_idxItem
|
|
|
|
DELETE FROM AnagItems
|
|
WHERE idxItem = @Original_idxItem
|
|
|
|
COMMIT tran
|
|
|
|
RETURN |