Search notes:

SQL Server: Virtual System Columns %%ROWDUMP%%

create table tq84_tab (
   id     uniqueidentifier,
   val_1  numeric,
   val_2  varchar(20)
);
insert into tq84_tab (val_1, val_2) values (42, 'forty-two'  );
insert into tq84_tab (val_1, val_2) values (99, 'ninety-nine');
select
   tab.id,
   tab.val_1,
   tab.val_2,
   tab.%%rowDump%%,
   crk.*
from
  tq84_tab                               tab cross apply
  sys.fn_rowDumpCracker(tab.%%rowDump%%) crk
drop table tq84_tab;

See also

Other virtual system columns.

Index