IF (Not EXISTS(select * from sys.syscolumn as C, sys.systable as T
where LCase(T.table_name) = LCase('RoomStatus') and LCase(C.column_name) = LCase('ShortDescription') and C.table_id=T.table_id)) THEN
  alter table RoomStatus add ShortDescription varchar(5)
END IF

GO

update RoomStatus set ShortDescription='нор' where RoomStatusNo=0
GO
update RoomStatus set ShortDescription='а' where RoomStatusNo=1
GO
update RoomStatus set ShortDescription='неп' where RoomStatusNo=2
GO
update RoomStatus set ShortDescription='нет' where RoomStatusNo=3
GO
update RoomStatus set ShortDescription='ч' where RoomStatusNo=10