ALTER PROCEDURE [dbo].[Del_Upd_DateMov] 
(
@codalbergo Int,
@DataArrivo As smalldatetime=Null,
@DataPartenza As smalldatetime=Null,
@SetDataPartenza As smalldatetime
)
AS
BEGIN
Delete From tab_alloggiati where codice_albergo=@codalbergo and data_arrivo between @dataarrivo and @datapartenza
END
BEGIN
Update tab_alloggiati
Set
Data_partenza=@SetDataPartenza
where codice_albergo=@codalbergo and data_partenza between @dataarrivo and @datapartenza
END