SQLSERVER DBCC PAGE

CREATE TABLE Variable
(
Col1 char(3) NOT NULL,
Col2 varchar(250) NOT NULL,
Col3 varchar(5) NULL,
Col4 varchar(20) NOT NULL,
Col5 smallint NULL
);

INSERT Variable VALUES
('AAA', REPLICATE('X', 250), NULL, 'ABC', 123);

INSERT Variable VALUES
('AAA', '壹', NULL, 'ABC', 123);

select  char('壹')
select * from Variable;

d2bc

select  ascii('壹')

select  convert ( binary(20),  '壹' )

DBCC IND(LYS,Variable,1)
DBCC TRACEON(3604)
DBCC PAGE(LYS,5,966832,3 )
DBCC PAGE(LYS,5,966832,3 ) with tableresults,no_infomsgs













SELECT object_id, type_desc,
indexproperty(object_id, name, 'minlen') as minlen
FROM sys.indexes where object_id=object_id('Variable');
SELECT name, column_id, max_inrow_length, pc.system_type_id, leaf_offset
FROM sys.system_internals_partition_columns pc
JOIN sys.partitions p
ON p.partition_id = pc.partition_id
JOIN sys.columns c
ON column_id = partition_column_id AND c.object_id = p.object_id
WHERE p.object_id=object_id('Variable');