Fols Scripts

-- purpose : UPDATE ROOM STATUS
-- author : AB
-- date : 23/02/16
-- comment : To apply on Exxxx
-- QC : 19727
-- ATTENTION : 3 valeurs en ROUGE a modifier


use eXXXX

Set nocount on
Declare @Error int
Declare @NbRec int

UPDATE ROOM_STATUS
SET RSTA_ID = 1, SERV_ID = NULL
FROM ROOM r INNER JOIN ROOM_STATUS rs ON r.ROOM_ID = rs.ROOM_ID
WHERE r.HOTE_ID=XXXX AND ROOM_NUM='numero de chambre'

set @NbRec = @@rowcount
Set @Error = @@error If @Error <> 0 Goto Err

Print 'Correction effectuée : ' + LTrim(Str(@NbRec)) + ' enregistrements affectés'

Err:
If @Error<> 0
Begin
Raiserror ('Error the treatment" - ERROR NUMBER : %d ', 16, -1,'', ' ', @Error)
End