insert into foo(bar_name)
 values(@bar_name_new);
if @@rowcount > 0 then
 select bar_id, bar_name from foo where bar_id = scope_identity();

insert into foo(bar_name)
 values(@bar_name_new);
 select bar_id, bar_name from foo where bar_id = (SELECT last_insert_rowid());

update foo
  set bar_name = @bar_name_new
  where bar_id = @bar_id_old and bar_name = @bar_name_old;
if @@rowcount > 0 then
 select bar_id, bar_name from foo where bar_id = @bar_id_old;

select
 case when changes() > 0 then id end,
 case when changes() > 0 then date end, 
 case when changes() > 0 then flattype end, 
 case when changes() > 0 then dealtype end, 
 case when changes() > 0 then address end, 
 case when changes() > 0 then square end, 
 case when changes() > 0 then floors end, 
 case when changes() > 0 then floor end, 
 case when changes() > 0 then balcony end,  
 case when changes() > 0 then price end, 
 case when changes() > 0 then contact end, 
 case when changes() > 0 then additional end
from flats where id=@idOld