CREATE table #T (s varchar(128))  DECLARE @T table (s varchar(128))  INSERT into #T select 'old value #'  INSERT into @T select 'old value @'  BEGIN transaction    UPDATE #T set s='new value #'    UPDATE @T set s='new value @'  ROLLBACK transaction  SELECT * from #T  SELECT * from @T