SELECT

  1,123,12345,1234567890,1234567890123456789,

  987654.3210,9876.543210,

  123456.7890,123456789012345.6789,

  1234567890.1234567890,1234567890.1234567890,

  '2010-01-01 23:59:59.123','2010-01-01','23:59:59. 1234567',

  '2010-01-01 23:59:59','2010-01-01 23:59:59.1234567','2010-01-01 23:59:59.1234567 +12:00',

  'abcd','abcd','王保强','王保强',

  CONVERT(BINARY,'123456'),CONVERT(BINARY,'123456'),

  '1234567890','1234567890',CONVERT(BINARY,'1234567890'),

  '1234567890','1234567890','1234567890'

--使用system_internals_allocation_units来获取该表的相关数据页

SELECT c.name,a.type_desc,

       total_pages,used_pages,data_pages,

       testdb.dbo.f_get_page(first_page) first_page_address,

       testdb.dbo.f_get_page(root_page) root_address,

       testdb.dbo.f_get_page(first_iam_page) IAM_address

  FROM sys.system_internals_allocation_units a,sys.partitions b,sys.objects c

 WHERE a.container_id=b.partition_id and b.object_id=c.object_id

   AND c.name in ('testDataType')   

--再使用dbcc page命令分析相关页面信息