由于本人还是SQLSERVER菜鸟一枚,加上一些实验的逻辑严谨性,
单写《SQLSERVER聚集索引与非聚集索引的再次研究(上)》就用了12个小时,两篇文章加起来最起码写了20个小时,
本人非常非常用心的努力完成这两篇文章,希望各位看官给点意见o(∩_∩)o
SQLSERVER聚集索引与非聚集索引的再次研究(上)
上篇主要说聚集索引
下篇的地址:SQLSERVER聚集索引与非聚集索引的再次研究(下)
由于本人还是SQLSERVER菜鸟一枚,加上一些实验的逻辑严谨性,
单写《SQLSERVER聚集索引与非聚集索引的再次研究(上)》就用了12个小时,两篇文章加起来最起码写了20个小时,
本人非常非常用心的努力完成这两篇文章,希望各位看官给点意见o(∩_∩)o
为了搞清楚索引内部工作原理和结构,真是千头万绪,这篇文章只是作为参考,里面的观点不一定正确
有一些问题,msdn里,网上的文章里,博客园里都有提到,但是这些问题的答案是正确的吗?其实有时候我自己都想知道答案
比如,画聚集索引的图,有一些人用表格来表示,但是他们正确吗?
以前知道聚集索引 非聚集索引是B树 二叉树结构,又知道执行计划图标很像二叉树很传神,但是还是觉得很抽象
这篇文章写完以后还是比较抽象但是最起码比以前清晰一些了
有很多问题不知道为什么,但是MSDN就是这样说的,既然说得这麽模糊不如自己做一下实验,验证一下MSDN的内容吧o(∩_∩)o
--------------------------------------------华丽的分割线---------------------------------------------
先来看一下索引的结构,文章里面的一些结构图都是自己画的一些草图,本人自认画得非常烂,希望各位看官谅解o(∩_∩)o
----------------------------------------------华丽的分割线---------------------------------------------------------
先创建一个表,保存DBCC IND的结果
1 CREATE TABLE DBCCResult (
2 PageFID NVARCHAR(200),
3 PagePID NVARCHAR(200),
4 IAMFID NVARCHAR(200),
5 IAMPID NVARCHAR(200),
6 ObjectID NVARCHAR(200),
7 IndexID NVARCHAR(200),
8 PartitionNumber NVARCHAR(200),
9 PartitionID NVARCHAR(200),
10 iam_chain_type NVARCHAR(200),
11 PageType NVARCHAR(200),
12 IndexLevel NVARCHAR(200),
13 NextPageFID NVARCHAR(200),
14 NextPagePID NVARCHAR(200),
15 PrevPageFID NVARCHAR(200),
16 PrevPagePID NVARCHAR(200)
17 )
创建一个聚集索引表
1 --只有聚集索引
2 CREATE TABLE Department(
3 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
4 Name NVARCHAR(200) NOT NULL,
5 GroupName NVARCHAR(200) NOT NULL,
6 Company NVARCHAR(300),
7 ModifiedDate datetime NOT NULL DEFAULT (getdate())
8 )
插入10W条记录
1 INSERT INTO Department(name,[Company],groupname) VALUES('销售部','中国你好有限公司XX分公司','销售组')
2 GO 100000
将DBCC IND的结果放入DBCCRESULT表
1 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department,-1) ')
查询Department表中的页面情况
先说明一下:
PageType 分页类型: 1:数据页面;2:索引页面;3:Lob_mixed_page;4:Lob_tree_page;10:IAM页面
IndexID 索引ID: 0 代表堆, 1 代表聚集索引, 2-250 代表非聚集索引 ,大于250就是text或image字段
红色框部分都是需要关注的
第一个:IAM页不是只有堆表才有也不只是维护堆表中的数据页的连续,有索引的表都有,所以IAM页不只维护数据页,也维护索引页的连续,在下篇说到非聚集索引的时候
我会给出MSDN的解释和IAM页在聚集索引表,非聚集索引表中的情况
第二个:每个数据页的IndexID都是1,不是说数据页变成了索引页,而是说现在数据页已经属于聚集索引的一部分,不在堆里了
第三个:每个数据页的IndexLevel都是0,就是说数据页在聚集索引的最下层
第四个:索引页和数据页,前一页和后一页是首尾相连的,但是数据页和索引页不是首尾相连的,也就是说没有一个数据页的[PrevPagePID]指向14464页或3528页
那么在上面的聚集索引图片中为什麽会说索引页指向数据页呢?叶子节点就是数据页呢?
数据页的index level是0,那么就是说聚集索引的叶子节点就是数据页
上面索引页的结构
现在来看一下索引页里都有什么,运行下面的SQL语句
1 DBCC TRACEON(3604,-1)
2 GO
3
4 DBCC PAGE([pratice],1,3527,3)
5 GO
6
7
8 DBCC PAGE([pratice],1,3528,3)
9 GO
10
11 DBCC PAGE([pratice],1,14464,3)
12 GO
您们应该看到ChildPageId,所以上面我的图为什麽会这样画的原因,索引页连接着数据页,而且一个索引页指向多个数据页
DepartmentID是主键列,从1开始自增,那么从下图可以看出主键列数据是从最左边的索引节点(不是叶子节点)开始排序
这里有个问题:为什麽根节点只有两行???是不是根节点只作连接作用,所以只有两行 ??
答:其实我们在建立索引的时候,会有一个默认选项:PAD_INDEX
PAD_INDEX 选项只作用于 非叶级索引页
如果PAD_INDEX未指定,则默认会为非叶级页留出一行空间
在非叶级页上的行数永远不会小于两行
聚集索引页里主键列DepartmentID上一行与下一行相差120条记录,一个数据页刚好容纳120条记录
KeyHashValue根据主键列的第一个字段而生成的,就算两个表完全一样,这个hash出来的KeyHashValue都不会一样
我创建了一个一模一样的表Department2,看到hash出来的值都不一样
------------------------------------------------------------华丽的分割线------------------------------------------------------
聚集索引怎麽找记录的???
这里要分两种情况:(1)聚集索引查找 (2)聚集索引扫描
(1)聚集索引查找
放大一下索引页
SQLSERVER聚集索引查找记录的流程
先用二分查找法找到实际的数据页面,然后再到数据页里把实际数据读出来
这里还有一个keyhashvalue用来锁定数据行资源, 运行下面的SQL语句,看一下SQLSERVER申请的锁就知道了
下面实验我在Department2表里做的,表数据和表结构和Department1一模一样
1 --只有聚集索引
2 CREATE TABLE Department2(
3 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
4 Name NVARCHAR(200) NOT NULL,
5 GroupName NVARCHAR(200) NOT NULL,
6 Company NVARCHAR(300),
7 ModifiedDate datetime NOT NULL DEFAULT (getdate())
8 )
9
10 INSERT INTO Department2(name,[Company],groupname) VALUES('销售部','中国你好有限公司XX分公司','销售组')
11 GO 100000
12
13
14 SELECT * FROM Department2
15
16 --先清空[DBCCResult]表里的记录
17 --TRUNCATE TABLE [dbo].[DBCCResult]
18 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department2,-1) ')
19
20 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
21
22 DBCC PAGE([pratice],1,14471,3)
23 GO
24
25 DBCC PAGE([pratice],1,4375,3)
26 GO
27 DBCC PAGE([pratice],1,4376,3)
28 GO
View Code
下面这个证明代码在《SQLSERVER企业级平台管理实践》里找的
USE 数据库
GO
SELECT
[request_session_id],
c.[program_name],
DB_NAME(c.[dbid]) AS dbname,
[resource_type],
[request_status],
[request_mode],
[resource_description],OBJECT_NAME(p.[object_id]) AS objectname,
p.[index_id]
FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p
ON a.[resource_associated_entity_id]=p.[hobt_id]
LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid]
WHERE c.[dbid]=DB_ID('数据库') --AND a.[request_session_id]=@@SPID
ORDER BY [request_session_id],[resource_type]
需要记住的是,B树索引本身并不能找到具体的一条记录,能找到的只是该记录所在的页面,数据库把页面载入到内存,这里算一个读I/O
对真个页面进行扫描,由于在内存中查找的一个页面里的一条记录很快,因此通常忽略这部分扫描所用的时间
二分查找只是个缩小查找范围的查找方法,本身作用于的对象是一个个的数据页面,要找到具体某条记录还需要读取整个页面到内存进行查找
(2)聚集索引扫描
先drop掉Department2表,然后重新创建Department2表
1 --只有聚集索引
2 CREATE TABLE Department2(
3 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
4 Name NVARCHAR(200) NOT NULL,
5 GroupName NVARCHAR(200) NOT NULL,
6 Company NVARCHAR(300),
7 ModifiedDate datetime NOT NULL DEFAULT (getdate())
8 )
9
10 DECLARE @i INT
11 SET @i=1
12 WHILE @i < 100000
13 BEGIN
14 INSERT INTO Department3 ( name, [Company], groupname )
15 VALUES ( '销售部', '中国你好有限公司XX分公司'+CAST(@i AS VARCHAR(200)), '销售组'+CAST(@i AS VARCHAR(200)) )
16 SET @i = @i + 1
17 END
18
19
20 SELECT * FROM Department2
View Code
证明:
1 USE [pratice]
2 GO
3 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
4 GO
5 --以下查询使用了聚集索引查找 ctrl+l
6 BEGIN TRAN
7 SELECT * FROM [dbo].[Department2] WHERE [GroupName] ='销售组83421'
8
9 --COMMIT TRAN
10
11 USE [pratice] --要查询申请锁的数据库
12 GO
13 SELECT
14 [request_session_id],
15 c.[program_name],
16 DB_NAME(c.[dbid]) AS dbname,
17 [resource_type],
18 [request_status],
19 [request_mode],
20 [resource_description],OBJECT_NAME(p.[object_id]) AS objectname,
21 p.[index_id]
22 FROM sys.[dm_tran_locks] AS a LEFT JOIN sys.[partitions] AS p
23 ON a.[resource_associated_entity_id]=p.[hobt_id]
24 LEFT JOIN sys.[sysprocesses] AS c ON a.[request_session_id]=c.[spid]
25 WHERE c.[dbid]=DB_ID('pratice') AND a.[request_session_id]=@@SPID ----要查询申请锁的数据库
26 ORDER BY [request_session_id],[resource_type]
View Code
上图“以下查询使用了聚集索引查找”,由于本人写SQL代码的时候没有修改上面注释,大家可以不用理会
为什麽会有一个键锁,那么多的页锁,在徐海蔚老师的《SQLSERVER企业级平台管理实践》的书本里第361页说到
因为在有聚集索引的表格上,数据是直接存放在索引的最底层(叶子节点),所以要扫描整个表格里的数据,就要把整个聚集索引
扫描一遍。在这里,聚集索引扫描就相当于一个表扫描。所要用的时间和资源与表扫描没有什么差别
SQLSERVER不会停止扫描数据页,所以才看到上图有那么多的页面上加了页锁,SQLSERVER需要逐个数据页逐个数据页去扫描就像堆表的全表扫描那样。
那个键锁是当SQLSERVER找到那条记录之后,需要在
记录的所在页面(即是索引页指向那个记录的数据页的那一行)加上一个键锁,以防止别人删除索引页的那一行记录
但是聚集索引扫描是不是一定比聚集索引查找要差呢?这个不一定,要看实际情况o(∩_∩)o
那么非聚集索引扫描是不是跟聚集索引扫描一样,所要用的时间和资源与表扫描没有什么差别呢???
大家可以看一下《SQLSERVER聚集索引与非聚集索引的再次研究(下)》本人做的一个小实验
实验证明了《SQLSERVER企业级平台管理实践》里第363页说到的内容
索引扫描表明SQLSERVER正在扫描一个非聚集索引。由于非聚集索引上一般只会有一小部分字段,所以这里虽然也是扫描,但是
代价会比整表扫描要小很多
------------------------------------------------华丽的分割线--------------------------------------------------------------------
这里有一个问题:没有主键但是有聚集索引,索引页的列数不一样,会多了一列,而这个列(uniquifier)的作用在下面会讲到
这里创建Department3表
1 --只有聚集索引
2 CREATE TABLE Department3(
3 DepartmentID int IDENTITY(1,1) NOT NULL ,
4 Name NVARCHAR(200) NOT NULL,
5 GroupName NVARCHAR(200) NOT NULL,
6 Company NVARCHAR(300),
7 ModifiedDate datetime NOT NULL DEFAULT (getdate())
8 )
9
10 CREATE CLUSTERED INDEX CL_DepartmentID ON [dbo].[Department3]([DepartmentID])
11
12 DECLARE @i INT
13 SET @i=1
14 WHILE @i < 100000
15 BEGIN
16 INSERT INTO Department3 ( name, [Company], groupname )
17 VALUES ( '销售部', '中国你好有限公司XX分公司'+CAST(@i AS VARCHAR(200)), '销售组'+CAST(@i AS VARCHAR(200)) )
18 SET @i = @i + 1
19 END
20
21
22 SELECT * FROM Department3
23
24 --TRUNCATE TABLE [dbo].[DBCCResult]
25
26 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department3,-1) ')
27
28 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
29
30 DBCC PAGE([pratice],1,13861,3)
31 GO
View Code
可以看到只有聚集索引没有主键的表会比主键表多了一列uniquifier列,这个列的作用会在创建Department5表的时候讲到
-----------------------------------------------华丽的分割线-------------------------------------------------------
下面说一下,复合主键或者聚集索引建立在多个字段上,KeyHashValue只会根据第一个字段生成hash key
当你查询的时候where 后面的字段不包含创建聚集索引时的第一个字段或者复合主键的第一个字段就会聚集索引扫描而不是聚集索引查找
创建Department4表
1 --只有聚集索引
2 CREATE TABLE Department4 --包含复合主键DepartmentID 和Name
3 (
4 DepartmentID INT IDENTITY(1, 1) NOT NULL ,
5 Name NVARCHAR(200) NOT NULL ,
6 GroupName NVARCHAR(200) NOT NULL ,
7 Company NVARCHAR(300) ,
8 ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) ,
9 CONSTRAINT [PK_Department4_1] PRIMARY KEY CLUSTERED
10 ( DepartmentID ASC,
11 Name ASC )
12 WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
13 ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
14 ) ON [PRIMARY]
15
16
17 DECLARE @i INT
18 SET @i=1
19 WHILE @i < 100000
20 BEGIN
21 INSERT INTO Department4 ( name, [Company], groupname )
22 VALUES ( '销售部'+CAST(@i AS VARCHAR(200)), '中国你好有限公司XX分公司', '销售组' )
23 SET @i = @i + 1
24 END
25
26
27 SELECT * FROM [dbo].[Department4]
28
29
30
31 --TRUNCATE TABLE [dbo].[DBCCResult]
32 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department4,-1) ')
33
34 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
35
36 DBCC PAGE([pratice],1,7102,3)
37 GO
View Code
1 SELECT * FROM [dbo].[Department4] WHERE name='销售部6' --聚集索引扫描 因为name不是复合主键中的第一个字段
2 SELECT * FROM [dbo].[Department4] WHERE name='销售部241' AND [DepartmentID]=241 --聚集索引查找
3 SELECT * FROM [dbo].[Department4] WHERE [DepartmentID]=241 --聚集索引查找
在建立聚集索引的时候在多个字段上建立聚集索引是没有任何意义的
因为聚集索引查找是根据建立索引的第一个字段来查找,索引扫描的时候会到数据页里扫描 ,而聚集索引的每一行只是一个数据页的范围值从而不能直接定位到要找的那条记录
所以只需要在数据表的一个字段上建立聚集索引就可以了,而究竟要在哪一个字段上建立聚集索引大家一定好好斟酌,本人建议那一个字段在order by中经常要排序的
因为数据页都已经按照聚集索引的第一个字段排好序的了
而不像非聚集索引的索引页跟数据表的记录一一对应,扫描的时候扫描索引页的每一行
大家可以对比一下聚集索引和非聚集索引页的结构
聚集索引页的结构
非聚集索引页的结构
非聚集索引页面的结构会在SQLSERVER聚集索引与非聚集索引的再次研究(下)里讲到
---------------------------------------------------------华丽的分割线-----------------------------------------------------
由于主键不允许重复值,那么就在表上创建一个不唯一的聚集索引,有人说在重复值很多的列上建立聚集索引没有意义
创建Department5表 在Company字段上建立聚集索引,Company字段的值全部都是"中国你好有限公司XX分公司"
1 --只有聚集索引
2 USE [pratice]
3 GO
4 CREATE TABLE Department5
5 (
6 DepartmentID INT IDENTITY(1, 1) NOT NULL ,
7 Name NVARCHAR(200) NOT NULL ,
8 GroupName NVARCHAR(200) NOT NULL ,
9 Company NVARCHAR(300) ,
10 ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() )
11 )
12
13 CREATE CLUSTERED INDEX CL_Company ON [dbo].[Department5]([Company] ASC)
14
15 --DROP TABLE [dbo].[Department5]
16
17 DECLARE @i INT
18 SET @i=1
19 WHILE @i < 10000
20 BEGIN
21 INSERT INTO Department5 ( name, [Company], groupname )
22 VALUES ( '销售部'+CAST(@i AS VARCHAR(200)), '中国你好有限公司XX分公司', '销售组' )
23 SET @i = @i + 1
24 END
View Code
1 --TRUNCATE TABLE [dbo].[DBCCResult]
2 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department5,-1) ')
3
4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
5
6 DBCC PAGE([pratice],1,14516,3)
7 GO
View Code
在Department3表的时候讲到列(uniquifier),为什麽有主键的表没有这个列,而聚集索引的表有这个列,原因在于
主键列不能有重复值,必须是唯一的,而聚集索引允许有重复值,所以聚集索引需要增加列(uniquifier)来区分重复值
而且可以看到这里uniquifier列是没有规律的,不像Department表每隔120行记录在索引页里标记一行
看一下执行计划和执行结果
1 SET STATISTICS TIME ON
2 SELECT * FROM [dbo].[Department5] WHERE [Company]='中国你好有限公司XX分公司' AND [DepartmentID]=241
3
4 SQL Server 分析和编译时间:
5 CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。
6
7 (1 行受影响)
8
9 SQL Server 执行时间:
10 CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。
1 SET STATISTICS TIME ON
2 SELECT * FROM [dbo].[Department5] WHERE name='销售部106' AND [DepartmentID]=106 --聚集索引扫描
3 SQL Server 执行时间:
4 CPU 时间 = 0 毫秒,占用时间 = 0 毫秒。
至于应不应该在重复值很多的列上建立聚集索引我这里也不敢妄下判断,因为实际环境和这里的测试环境不一样
在MSDN中的解释:http://msdn.microsoft.com/zh-cn/library/ms177484(v=SQL.105).aspx
如果聚集索引不是唯一的索引,SQL Server 将添加在内部生成的值(称为唯一值)以使所有重复键唯一。此四字节的值对于用户不可见
还有一个,看一下叶子节点中的数据页,在每个数据页的每行记录中都有
Slot 101 Column 0 Offset 0x1d Length 4
UNIQUIFIER = 206
因为需要标记索引列中的唯一,所以需要在每行记录中增加一列UNIQUIFIER ,但是这一列在select * 表中数据的时候是select不出来的
还有人说UNIQUIFIER 是一个可变长度的字段,但是Length 4已经说明了是一个占用4字节的字段
1 PAGE: (1:14517)
2
3
4 BUFFER:
5
6
7 BUF @0x03EC9D64
8
9 bpage = 0x1A096000 bhash = 0x00000000 bpageno = (1:14517)
10 bdbid = 5 breferences = 0 bUse1 = 4722
11 bstat = 0x3c00009 blog = 0x32159 bnext = 0x00000000
12
13 PAGE HEADER:
14
15
16 Page @0x1A096000
17
18 m_pageId = (1:14517) m_headerVersion = 1 m_type = 1
19 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x200
20 m_objId (AllocUnitId.idObj) = 317 m_indexId (AllocUnitId.idInd) = 256
21 Metadata: AllocUnitId = 72057594058702848
22 Metadata: PartitionId = 72057594049462272 Metadata: IndexId = 1
23 Metadata: ObjectId = 1022626686 m_prevPage = (1:14514) m_nextPage = (1:14518)
24 pminlen = 16 m_slotCnt = 102 m_freeCnt = 38
25 m_freeData = 7950 m_reservedCnt = 0 m_lsn = (2568:5252:8)
26 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
27 m_tornBits = -1007571449
28
29 Allocation Status
30
31 GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
32 PFS (1:8088) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = NOT CHANGED
33 ML (1:7) = NOT MIN_LOGGED
34
35 Slot 0 Offset 0x60 Length 77
36
37 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
38
39 Memory Dump @0x0A64C060
40
41 00000000: 30001000 6a000000 d42e7c01 fea10000 †0...j.....|.....
42 00000010: 0600c004 0021003b 0047004d 00690000 †.....!.;.G.M.i..
43 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
44 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
45 00000040: 90310030 00360000 952e55c4 7e††††††††.1.0.6....U.~
46
47 Slot 0 Column 0 Offset 0x1d Length 4
48
49 UNIQUIFIER = 105
50
51 Slot 0 Column 1 Offset 0x21 Length 26
52
53 Company = 中国你好有限公司XX分公司
54
55 Slot 0 Column 2 Offset 0x4 Length 4
56
57 DepartmentID = 106
58
59 Slot 0 Column 3 Offset 0x3b Length 12
60
61 Name = 销售部106
62
63 Slot 0 Column 4 Offset 0x47 Length 6
64
65 GroupName = 销售组
66
67 Slot 0 Column 5 Offset 0x8 Length 8
68
69 ModifiedDate = 07 17 2013 11:04PM
70
71 Slot 1 Offset 0xad Length 77
72
73 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
74
75 Memory Dump @0x0A64C0AD
76
77 00000000: 30001000 6b000000 d42e7c01 fea10000 †0...k.....|.....
78 00000010: 0600c004 0021003b 0047004d 006a0000 †.....!.;.G.M.j..
79 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
80 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
81 00000040: 90310030 00370000 952e55c4 7e††††††††.1.0.7....U.~
82
83 Slot 1 Column 0 Offset 0x1d Length 4
84
85 UNIQUIFIER = 106
86
87 Slot 1 Column 1 Offset 0x21 Length 26
88
89 Company = 中国你好有限公司XX分公司
90
91 Slot 1 Column 2 Offset 0x4 Length 4
92
93 DepartmentID = 107
94
95 Slot 1 Column 3 Offset 0x3b Length 12
96
97 Name = 销售部107
98
99 Slot 1 Column 4 Offset 0x47 Length 6
100
101 GroupName = 销售组
102
103 Slot 1 Column 5 Offset 0x8 Length 8
104
105 ModifiedDate = 07 17 2013 11:04PM
106
107 Slot 2 Offset 0xfa Length 77
108
109 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
110
111 Memory Dump @0x0A64C0FA
112
113 00000000: 30001000 6c000000 d42e7c01 fea10000 †0...l.....|.....
114 00000010: 0600c004 0021003b 0047004d 006b0000 †.....!.;.G.M.k..
115 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
116 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
117 00000040: 90310030 00380000 952e55c4 7e††††††††.1.0.8....U.~
118
119 Slot 2 Column 0 Offset 0x1d Length 4
120
121 UNIQUIFIER = 107
122
123 Slot 2 Column 1 Offset 0x21 Length 26
124
125 Company = 中国你好有限公司XX分公司
126
127 Slot 2 Column 2 Offset 0x4 Length 4
128
129 DepartmentID = 108
130
131 Slot 2 Column 3 Offset 0x3b Length 12
132
133 Name = 销售部108
134
135 Slot 2 Column 4 Offset 0x47 Length 6
136
137 GroupName = 销售组
138
139 Slot 2 Column 5 Offset 0x8 Length 8
140
141 ModifiedDate = 07 17 2013 11:04PM
142
143 Slot 3 Offset 0x147 Length 77
144
145 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
146
147 Memory Dump @0x0A64C147
148
149 00000000: 30001000 6d000000 d42e7c01 fea10000 †0...m.....|.....
150 00000010: 0600c004 0021003b 0047004d 006c0000 †.....!.;.G.M.l..
151 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
152 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
153 00000040: 90310030 00390000 952e55c4 7e††††††††.1.0.9....U.~
154
155 Slot 3 Column 0 Offset 0x1d Length 4
156
157 UNIQUIFIER = 108
158
159 Slot 3 Column 1 Offset 0x21 Length 26
160
161 Company = 中国你好有限公司XX分公司
162
163 Slot 3 Column 2 Offset 0x4 Length 4
164
165 DepartmentID = 109
166
167 Slot 3 Column 3 Offset 0x3b Length 12
168
169 Name = 销售部109
170
171 Slot 3 Column 4 Offset 0x47 Length 6
172
173 GroupName = 销售组
174
175 Slot 3 Column 5 Offset 0x8 Length 8
176
177 ModifiedDate = 07 17 2013 11:04PM
178
179 Slot 4 Offset 0x194 Length 77
180
181 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
182
183 Memory Dump @0x0A64C194
184
185 00000000: 30001000 6e000000 d42e7c01 fea10000 †0...n.....|.....
186 00000010: 0600c004 0021003b 0047004d 006d0000 †.....!.;.G.M.m..
187 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
188 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
189 00000040: 90310031 00300000 952e55c4 7e††††††††.1.1.0....U.~
190
191 Slot 4 Column 0 Offset 0x1d Length 4
192
193 UNIQUIFIER = 109
194
195 Slot 4 Column 1 Offset 0x21 Length 26
196
197 Company = 中国你好有限公司XX分公司
198
199 Slot 4 Column 2 Offset 0x4 Length 4
200
201 DepartmentID = 110
202
203 Slot 4 Column 3 Offset 0x3b Length 12
204
205 Name = 销售部110
206
207 Slot 4 Column 4 Offset 0x47 Length 6
208
209 GroupName = 销售组
210
211 Slot 4 Column 5 Offset 0x8 Length 8
212
213 ModifiedDate = 07 17 2013 11:04PM
214
215 Slot 5 Offset 0x1e1 Length 77
216
217 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
218
219 Memory Dump @0x0A64C1E1
220
221 00000000: 30001000 6f000000 d42e7c01 fea10000 †0...o.....|.....
222 00000010: 0600c004 0021003b 0047004d 006e0000 †.....!.;.G.M.n..
223 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
224 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
225 00000040: 90310031 00310000 952e55c4 7e††††††††.1.1.1....U.~
226
227 Slot 5 Column 0 Offset 0x1d Length 4
228
229 UNIQUIFIER = 110
230
231 Slot 5 Column 1 Offset 0x21 Length 26
232
233 Company = 中国你好有限公司XX分公司
234
235 Slot 5 Column 2 Offset 0x4 Length 4
236
237 DepartmentID = 111
238
239 Slot 5 Column 3 Offset 0x3b Length 12
240
241 Name = 销售部111
242
243 Slot 5 Column 4 Offset 0x47 Length 6
244
245 GroupName = 销售组
246
247 Slot 5 Column 5 Offset 0x8 Length 8
248
249 ModifiedDate = 07 17 2013 11:04PM
250
251 Slot 6 Offset 0x22e Length 77
252
253 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
254
255 Memory Dump @0x0A64C22E
256
257 00000000: 30001000 70000000 d42e7c01 fea10000 †0...p.....|.....
258 00000010: 0600c004 0021003b 0047004d 006f0000 †.....!.;.G.M.o..
259 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
260 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
261 00000040: 90310031 00320000 952e55c4 7e††††††††.1.1.2....U.~
262
263 Slot 6 Column 0 Offset 0x1d Length 4
264
265 UNIQUIFIER = 111
266
267 Slot 6 Column 1 Offset 0x21 Length 26
268
269 Company = 中国你好有限公司XX分公司
270
271 Slot 6 Column 2 Offset 0x4 Length 4
272
273 DepartmentID = 112
274
275 Slot 6 Column 3 Offset 0x3b Length 12
276
277 Name = 销售部112
278
279 Slot 6 Column 4 Offset 0x47 Length 6
280
281 GroupName = 销售组
282
283 Slot 6 Column 5 Offset 0x8 Length 8
284
285 ModifiedDate = 07 17 2013 11:04PM
286
287 Slot 7 Offset 0x27b Length 77
288
289 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
290
291 Memory Dump @0x0A64C27B
292
293 00000000: 30001000 71000000 d42e7c01 fea10000 †0...q.....|.....
294 00000010: 0600c004 0021003b 0047004d 00700000 †.....!.;.G.M.p..
295 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
296 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
297 00000040: 90310031 00330000 952e55c4 7e††††††††.1.1.3....U.~
298
299 Slot 7 Column 0 Offset 0x1d Length 4
300
301 UNIQUIFIER = 112
302
303 Slot 7 Column 1 Offset 0x21 Length 26
304
305 Company = 中国你好有限公司XX分公司
306
307 Slot 7 Column 2 Offset 0x4 Length 4
308
309 DepartmentID = 113
310
311 Slot 7 Column 3 Offset 0x3b Length 12
312
313 Name = 销售部113
314
315 Slot 7 Column 4 Offset 0x47 Length 6
316
317 GroupName = 销售组
318
319 Slot 7 Column 5 Offset 0x8 Length 8
320
321 ModifiedDate = 07 17 2013 11:04PM
322
323 Slot 8 Offset 0x2c8 Length 77
324
325 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
326
327 Memory Dump @0x0A64C2C8
328
329 00000000: 30001000 72000000 d42e7c01 fea10000 †0...r.....|.....
330 00000010: 0600c004 0021003b 0047004d 00710000 †.....!.;.G.M.q..
331 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
332 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
333 00000040: 90310031 00340000 952e55c4 7e††††††††.1.1.4....U.~
334
335 Slot 8 Column 0 Offset 0x1d Length 4
336
337 UNIQUIFIER = 113
338
339 Slot 8 Column 1 Offset 0x21 Length 26
340
341 Company = 中国你好有限公司XX分公司
342
343 Slot 8 Column 2 Offset 0x4 Length 4
344
345 DepartmentID = 114
346
347 Slot 8 Column 3 Offset 0x3b Length 12
348
349 Name = 销售部114
350
351 Slot 8 Column 4 Offset 0x47 Length 6
352
353 GroupName = 销售组
354
355 Slot 8 Column 5 Offset 0x8 Length 8
356
357 ModifiedDate = 07 17 2013 11:04PM
358
359 Slot 9 Offset 0x315 Length 77
360
361 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
362
363 Memory Dump @0x0A64C315
364
365 00000000: 30001000 73000000 d42e7c01 fea10000 †0...s.....|.....
366 00000010: 0600c004 0021003b 0047004d 00720000 †.....!.;.G.M.r..
367 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
368 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
369 00000040: 90310031 00350000 952e55c4 7e††††††††.1.1.5....U.~
370
371 Slot 9 Column 0 Offset 0x1d Length 4
372
373 UNIQUIFIER = 114
374
375 Slot 9 Column 1 Offset 0x21 Length 26
376
377 Company = 中国你好有限公司XX分公司
378
379 Slot 9 Column 2 Offset 0x4 Length 4
380
381 DepartmentID = 115
382
383 Slot 9 Column 3 Offset 0x3b Length 12
384
385 Name = 销售部115
386
387 Slot 9 Column 4 Offset 0x47 Length 6
388
389 GroupName = 销售组
390
391 Slot 9 Column 5 Offset 0x8 Length 8
392
393 ModifiedDate = 07 17 2013 11:04PM
394
395 Slot 10 Offset 0x362 Length 77
396
397 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
398
399 Memory Dump @0x0A64C362
400
401 00000000: 30001000 74000000 d52e7c01 fea10000 †0...t.....|.....
402 00000010: 0600c004 0021003b 0047004d 00730000 †.....!.;.G.M.s..
403 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
404 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
405 00000040: 90310031 00360000 952e55c4 7e††††††††.1.1.6....U.~
406
407 Slot 10 Column 0 Offset 0x1d Length 4
408
409 UNIQUIFIER = 115
410
411 Slot 10 Column 1 Offset 0x21 Length 26
412
413 Company = 中国你好有限公司XX分公司
414
415 Slot 10 Column 2 Offset 0x4 Length 4
416
417 DepartmentID = 116
418
419 Slot 10 Column 3 Offset 0x3b Length 12
420
421 Name = 销售部116
422
423 Slot 10 Column 4 Offset 0x47 Length 6
424
425 GroupName = 销售组
426
427 Slot 10 Column 5 Offset 0x8 Length 8
428
429 ModifiedDate = 07 17 2013 11:04PM
430
431 Slot 11 Offset 0x3af Length 77
432
433 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
434
435 Memory Dump @0x0A64C3AF
436
437 00000000: 30001000 75000000 d52e7c01 fea10000 †0...u.....|.....
438 00000010: 0600c004 0021003b 0047004d 00740000 †.....!.;.G.M.t..
439 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
440 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
441 00000040: 90310031 00370000 952e55c4 7e††††††††.1.1.7....U.~
442
443 Slot 11 Column 0 Offset 0x1d Length 4
444
445 UNIQUIFIER = 116
446
447 Slot 11 Column 1 Offset 0x21 Length 26
448
449 Company = 中国你好有限公司XX分公司
450
451 Slot 11 Column 2 Offset 0x4 Length 4
452
453 DepartmentID = 117
454
455 Slot 11 Column 3 Offset 0x3b Length 12
456
457 Name = 销售部117
458
459 Slot 11 Column 4 Offset 0x47 Length 6
460
461 GroupName = 销售组
462
463 Slot 11 Column 5 Offset 0x8 Length 8
464
465 ModifiedDate = 07 17 2013 11:04PM
466
467 Slot 12 Offset 0x3fc Length 77
468
469 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
470
471 Memory Dump @0x0A64C3FC
472
473 00000000: 30001000 76000000 d52e7c01 fea10000 †0...v.....|.....
474 00000010: 0600c004 0021003b 0047004d 00750000 †.....!.;.G.M.u..
475 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
476 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
477 00000040: 90310031 00380000 952e55c4 7e††††††††.1.1.8....U.~
478
479 Slot 12 Column 0 Offset 0x1d Length 4
480
481 UNIQUIFIER = 117
482
483 Slot 12 Column 1 Offset 0x21 Length 26
484
485 Company = 中国你好有限公司XX分公司
486
487 Slot 12 Column 2 Offset 0x4 Length 4
488
489 DepartmentID = 118
490
491 Slot 12 Column 3 Offset 0x3b Length 12
492
493 Name = 销售部118
494
495 Slot 12 Column 4 Offset 0x47 Length 6
496
497 GroupName = 销售组
498
499 Slot 12 Column 5 Offset 0x8 Length 8
500
501 ModifiedDate = 07 17 2013 11:04PM
502
503 Slot 13 Offset 0x449 Length 77
504
505 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
506
507 Memory Dump @0x0A64C449
508
509 00000000: 30001000 77000000 d52e7c01 fea10000 †0...w.....|.....
510 00000010: 0600c004 0021003b 0047004d 00760000 †.....!.;.G.M.v..
511 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
512 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
513 00000040: 90310031 00390000 952e55c4 7e††††††††.1.1.9....U.~
514
515 Slot 13 Column 0 Offset 0x1d Length 4
516
517 UNIQUIFIER = 118
518
519 Slot 13 Column 1 Offset 0x21 Length 26
520
521 Company = 中国你好有限公司XX分公司
522
523 Slot 13 Column 2 Offset 0x4 Length 4
524
525 DepartmentID = 119
526
527 Slot 13 Column 3 Offset 0x3b Length 12
528
529 Name = 销售部119
530
531 Slot 13 Column 4 Offset 0x47 Length 6
532
533 GroupName = 销售组
534
535 Slot 13 Column 5 Offset 0x8 Length 8
536
537 ModifiedDate = 07 17 2013 11:04PM
538
539 Slot 14 Offset 0x496 Length 77
540
541 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
542
543 Memory Dump @0x0A64C496
544
545 00000000: 30001000 78000000 d52e7c01 fea10000 †0...x.....|.....
546 00000010: 0600c004 0021003b 0047004d 00770000 †.....!.;.G.M.w..
547 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
548 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
549 00000040: 90310032 00300000 952e55c4 7e††††††††.1.2.0....U.~
550
551 Slot 14 Column 0 Offset 0x1d Length 4
552
553 UNIQUIFIER = 119
554
555 Slot 14 Column 1 Offset 0x21 Length 26
556
557 Company = 中国你好有限公司XX分公司
558
559 Slot 14 Column 2 Offset 0x4 Length 4
560
561 DepartmentID = 120
562
563 Slot 14 Column 3 Offset 0x3b Length 12
564
565 Name = 销售部120
566
567 Slot 14 Column 4 Offset 0x47 Length 6
568
569 GroupName = 销售组
570
571 Slot 14 Column 5 Offset 0x8 Length 8
572
573 ModifiedDate = 07 17 2013 11:04PM
574
575 Slot 15 Offset 0x4e3 Length 77
576
577 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
578
579 Memory Dump @0x0A64C4E3
580
581 00000000: 30001000 79000000 d52e7c01 fea10000 †0...y.....|.....
582 00000010: 0600c004 0021003b 0047004d 00780000 †.....!.;.G.M.x..
583 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
584 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
585 00000040: 90310032 00310000 952e55c4 7e††††††††.1.2.1....U.~
586
587 Slot 15 Column 0 Offset 0x1d Length 4
588
589 UNIQUIFIER = 120
590
591 Slot 15 Column 1 Offset 0x21 Length 26
592
593 Company = 中国你好有限公司XX分公司
594
595 Slot 15 Column 2 Offset 0x4 Length 4
596
597 DepartmentID = 121
598
599 Slot 15 Column 3 Offset 0x3b Length 12
600
601 Name = 销售部121
602
603 Slot 15 Column 4 Offset 0x47 Length 6
604
605 GroupName = 销售组
606
607 Slot 15 Column 5 Offset 0x8 Length 8
608
609 ModifiedDate = 07 17 2013 11:04PM
610
611 Slot 16 Offset 0x530 Length 77
612
613 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
614
615 Memory Dump @0x0A64C530
616
617 00000000: 30001000 7a000000 d52e7c01 fea10000 †0...z.....|.....
618 00000010: 0600c004 0021003b 0047004d 00790000 †.....!.;.G.M.y..
619 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
620 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
621 00000040: 90310032 00320000 952e55c4 7e††††††††.1.2.2....U.~
622
623 Slot 16 Column 0 Offset 0x1d Length 4
624
625 UNIQUIFIER = 121
626
627 Slot 16 Column 1 Offset 0x21 Length 26
628
629 Company = 中国你好有限公司XX分公司
630
631 Slot 16 Column 2 Offset 0x4 Length 4
632
633 DepartmentID = 122
634
635 Slot 16 Column 3 Offset 0x3b Length 12
636
637 Name = 销售部122
638
639 Slot 16 Column 4 Offset 0x47 Length 6
640
641 GroupName = 销售组
642
643 Slot 16 Column 5 Offset 0x8 Length 8
644
645 ModifiedDate = 07 17 2013 11:04PM
646
647 Slot 17 Offset 0x57d Length 77
648
649 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
650
651 Memory Dump @0x0A64C57D
652
653 00000000: 30001000 7b000000 d52e7c01 fea10000 †0...{.....|.....
654 00000010: 0600c004 0021003b 0047004d 007a0000 †.....!.;.G.M.z..
655 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
656 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
657 00000040: 90310032 00330000 952e55c4 7e††††††††.1.2.3....U.~
658
659 Slot 17 Column 0 Offset 0x1d Length 4
660
661 UNIQUIFIER = 122
662
663 Slot 17 Column 1 Offset 0x21 Length 26
664
665 Company = 中国你好有限公司XX分公司
666
667 Slot 17 Column 2 Offset 0x4 Length 4
668
669 DepartmentID = 123
670
671 Slot 17 Column 3 Offset 0x3b Length 12
672
673 Name = 销售部123
674
675 Slot 17 Column 4 Offset 0x47 Length 6
676
677 GroupName = 销售组
678
679 Slot 17 Column 5 Offset 0x8 Length 8
680
681 ModifiedDate = 07 17 2013 11:04PM
682
683 Slot 18 Offset 0x5ca Length 77
684
685 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
686
687 Memory Dump @0x0A64C5CA
688
689 00000000: 30001000 7c000000 d52e7c01 fea10000 †0...|.....|.....
690 00000010: 0600c004 0021003b 0047004d 007b0000 †.....!.;.G.M.{..
691 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
692 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
693 00000040: 90310032 00340000 952e55c4 7e††††††††.1.2.4....U.~
694
695 Slot 18 Column 0 Offset 0x1d Length 4
696
697 UNIQUIFIER = 123
698
699 Slot 18 Column 1 Offset 0x21 Length 26
700
701 Company = 中国你好有限公司XX分公司
702
703 Slot 18 Column 2 Offset 0x4 Length 4
704
705 DepartmentID = 124
706
707 Slot 18 Column 3 Offset 0x3b Length 12
708
709 Name = 销售部124
710
711 Slot 18 Column 4 Offset 0x47 Length 6
712
713 GroupName = 销售组
714
715 Slot 18 Column 5 Offset 0x8 Length 8
716
717 ModifiedDate = 07 17 2013 11:04PM
718
719 Slot 19 Offset 0x617 Length 77
720
721 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
722
723 Memory Dump @0x0A64C617
724
725 00000000: 30001000 7d000000 d52e7c01 fea10000 †0...}.....|.....
726 00000010: 0600c004 0021003b 0047004d 007c0000 †.....!.;.G.M.|..
727 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
728 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
729 00000040: 90310032 00350000 952e55c4 7e††††††††.1.2.5....U.~
730
731 Slot 19 Column 0 Offset 0x1d Length 4
732
733 UNIQUIFIER = 124
734
735 Slot 19 Column 1 Offset 0x21 Length 26
736
737 Company = 中国你好有限公司XX分公司
738
739 Slot 19 Column 2 Offset 0x4 Length 4
740
741 DepartmentID = 125
742
743 Slot 19 Column 3 Offset 0x3b Length 12
744
745 Name = 销售部125
746
747 Slot 19 Column 4 Offset 0x47 Length 6
748
749 GroupName = 销售组
750
751 Slot 19 Column 5 Offset 0x8 Length 8
752
753 ModifiedDate = 07 17 2013 11:04PM
754
755 Slot 20 Offset 0x664 Length 77
756
757 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
758
759 Memory Dump @0x0A64C664
760
761 00000000: 30001000 7e000000 d52e7c01 fea10000 †0...~.....|.....
762 00000010: 0600c004 0021003b 0047004d 007d0000 †.....!.;.G.M.}..
763 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
764 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
765 00000040: 90310032 00360000 952e55c4 7e††††††††.1.2.6....U.~
766
767 Slot 20 Column 0 Offset 0x1d Length 4
768
769 UNIQUIFIER = 125
770
771 Slot 20 Column 1 Offset 0x21 Length 26
772
773 Company = 中国你好有限公司XX分公司
774
775 Slot 20 Column 2 Offset 0x4 Length 4
776
777 DepartmentID = 126
778
779 Slot 20 Column 3 Offset 0x3b Length 12
780
781 Name = 销售部126
782
783 Slot 20 Column 4 Offset 0x47 Length 6
784
785 GroupName = 销售组
786
787 Slot 20 Column 5 Offset 0x8 Length 8
788
789 ModifiedDate = 07 17 2013 11:04PM
790
791 Slot 21 Offset 0x6b1 Length 77
792
793 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
794
795 Memory Dump @0x0A64C6B1
796
797 00000000: 30001000 7f000000 d52e7c01 fea10000 †0.........|.....
798 00000010: 0600c004 0021003b 0047004d 007e0000 †.....!.;.G.M.~..
799 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
800 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
801 00000040: 90310032 00370000 952e55c4 7e††††††††.1.2.7....U.~
802
803 Slot 21 Column 0 Offset 0x1d Length 4
804
805 UNIQUIFIER = 126
806
807 Slot 21 Column 1 Offset 0x21 Length 26
808
809 Company = 中国你好有限公司XX分公司
810
811 Slot 21 Column 2 Offset 0x4 Length 4
812
813 DepartmentID = 127
814
815 Slot 21 Column 3 Offset 0x3b Length 12
816
817 Name = 销售部127
818
819 Slot 21 Column 4 Offset 0x47 Length 6
820
821 GroupName = 销售组
822
823 Slot 21 Column 5 Offset 0x8 Length 8
824
825 ModifiedDate = 07 17 2013 11:04PM
826
827 Slot 22 Offset 0x6fe Length 77
828
829 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
830
831 Memory Dump @0x0A64C6FE
832
833 00000000: 30001000 80000000 d52e7c01 fea10000 †0.........|.....
834 00000010: 0600c004 0021003b 0047004d 007f0000 †.....!.;.G.M....
835 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
836 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
837 00000040: 90310032 00380000 952e55c4 7e††††††††.1.2.8....U.~
838
839 Slot 22 Column 0 Offset 0x1d Length 4
840
841 UNIQUIFIER = 127
842
843 Slot 22 Column 1 Offset 0x21 Length 26
844
845 Company = 中国你好有限公司XX分公司
846
847 Slot 22 Column 2 Offset 0x4 Length 4
848
849 DepartmentID = 128
850
851 Slot 22 Column 3 Offset 0x3b Length 12
852
853 Name = 销售部128
854
855 Slot 22 Column 4 Offset 0x47 Length 6
856
857 GroupName = 销售组
858
859 Slot 22 Column 5 Offset 0x8 Length 8
860
861 ModifiedDate = 07 17 2013 11:04PM
862
863 Slot 23 Offset 0x74b Length 77
864
865 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
866
867 Memory Dump @0x0A64C74B
868
869 00000000: 30001000 81000000 d52e7c01 fea10000 †0.........|.....
870 00000010: 0600c004 0021003b 0047004d 00800000 †.....!.;.G.M....
871 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
872 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
873 00000040: 90310032 00390000 952e55c4 7e††††††††.1.2.9....U.~
874
875 Slot 23 Column 0 Offset 0x1d Length 4
876
877 UNIQUIFIER = 128
878
879 Slot 23 Column 1 Offset 0x21 Length 26
880
881 Company = 中国你好有限公司XX分公司
882
883 Slot 23 Column 2 Offset 0x4 Length 4
884
885 DepartmentID = 129
886
887 Slot 23 Column 3 Offset 0x3b Length 12
888
889 Name = 销售部129
890
891 Slot 23 Column 4 Offset 0x47 Length 6
892
893 GroupName = 销售组
894
895 Slot 23 Column 5 Offset 0x8 Length 8
896
897 ModifiedDate = 07 17 2013 11:04PM
898
899 Slot 24 Offset 0x798 Length 77
900
901 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
902
903 Memory Dump @0x0A64C798
904
905 00000000: 30001000 82000000 d52e7c01 fea10000 †0.........|.....
906 00000010: 0600c004 0021003b 0047004d 00810000 †.....!.;.G.M....
907 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
908 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
909 00000040: 90310033 00300000 952e55c4 7e††††††††.1.3.0....U.~
910
911 Slot 24 Column 0 Offset 0x1d Length 4
912
913 UNIQUIFIER = 129
914
915 Slot 24 Column 1 Offset 0x21 Length 26
916
917 Company = 中国你好有限公司XX分公司
918
919 Slot 24 Column 2 Offset 0x4 Length 4
920
921 DepartmentID = 130
922
923 Slot 24 Column 3 Offset 0x3b Length 12
924
925 Name = 销售部130
926
927 Slot 24 Column 4 Offset 0x47 Length 6
928
929 GroupName = 销售组
930
931 Slot 24 Column 5 Offset 0x8 Length 8
932
933 ModifiedDate = 07 17 2013 11:04PM
934
935 Slot 25 Offset 0x7e5 Length 77
936
937 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
938
939 Memory Dump @0x0A64C7E5
940
941 00000000: 30001000 83000000 d52e7c01 fea10000 †0.........|.....
942 00000010: 0600c004 0021003b 0047004d 00820000 †.....!.;.G.M....
943 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
944 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
945 00000040: 90310033 00310000 952e55c4 7e††††††††.1.3.1....U.~
946
947 Slot 25 Column 0 Offset 0x1d Length 4
948
949 UNIQUIFIER = 130
950
951 Slot 25 Column 1 Offset 0x21 Length 26
952
953 Company = 中国你好有限公司XX分公司
954
955 Slot 25 Column 2 Offset 0x4 Length 4
956
957 DepartmentID = 131
958
959 Slot 25 Column 3 Offset 0x3b Length 12
960
961 Name = 销售部131
962
963 Slot 25 Column 4 Offset 0x47 Length 6
964
965 GroupName = 销售组
966
967 Slot 25 Column 5 Offset 0x8 Length 8
968
969 ModifiedDate = 07 17 2013 11:04PM
970
971 Slot 26 Offset 0x832 Length 77
972
973 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
974
975 Memory Dump @0x0A64C832
976
977 00000000: 30001000 84000000 d52e7c01 fea10000 †0.........|.....
978 00000010: 0600c004 0021003b 0047004d 00830000 †.....!.;.G.M....
979 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
980 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
981 00000040: 90310033 00320000 952e55c4 7e††††††††.1.3.2....U.~
982
983 Slot 26 Column 0 Offset 0x1d Length 4
984
985 UNIQUIFIER = 131
986
987 Slot 26 Column 1 Offset 0x21 Length 26
988
989 Company = 中国你好有限公司XX分公司
990
991 Slot 26 Column 2 Offset 0x4 Length 4
992
993 DepartmentID = 132
994
995 Slot 26 Column 3 Offset 0x3b Length 12
996
997 Name = 销售部132
998
999 Slot 26 Column 4 Offset 0x47 Length 6
1000
1001 GroupName = 销售组
1002
1003 Slot 26 Column 5 Offset 0x8 Length 8
1004
1005 ModifiedDate = 07 17 2013 11:04PM
1006
1007 Slot 27 Offset 0x87f Length 77
1008
1009 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1010
1011 Memory Dump @0x0A64C87F
1012
1013 00000000: 30001000 85000000 d52e7c01 fea10000 †0.........|.....
1014 00000010: 0600c004 0021003b 0047004d 00840000 †.....!.;.G.M....
1015 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1016 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1017 00000040: 90310033 00330000 952e55c4 7e††††††††.1.3.3....U.~
1018
1019 Slot 27 Column 0 Offset 0x1d Length 4
1020
1021 UNIQUIFIER = 132
1022
1023 Slot 27 Column 1 Offset 0x21 Length 26
1024
1025 Company = 中国你好有限公司XX分公司
1026
1027 Slot 27 Column 2 Offset 0x4 Length 4
1028
1029 DepartmentID = 133
1030
1031 Slot 27 Column 3 Offset 0x3b Length 12
1032
1033 Name = 销售部133
1034
1035 Slot 27 Column 4 Offset 0x47 Length 6
1036
1037 GroupName = 销售组
1038
1039 Slot 27 Column 5 Offset 0x8 Length 8
1040
1041 ModifiedDate = 07 17 2013 11:04PM
1042
1043 Slot 28 Offset 0x8cc Length 77
1044
1045 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1046
1047 Memory Dump @0x0A64C8CC
1048
1049 00000000: 30001000 86000000 d52e7c01 fea10000 †0.........|.....
1050 00000010: 0600c004 0021003b 0047004d 00850000 †.....!.;.G.M....
1051 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1052 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1053 00000040: 90310033 00340000 952e55c4 7e††††††††.1.3.4....U.~
1054
1055 Slot 28 Column 0 Offset 0x1d Length 4
1056
1057 UNIQUIFIER = 133
1058
1059 Slot 28 Column 1 Offset 0x21 Length 26
1060
1061 Company = 中国你好有限公司XX分公司
1062
1063 Slot 28 Column 2 Offset 0x4 Length 4
1064
1065 DepartmentID = 134
1066
1067 Slot 28 Column 3 Offset 0x3b Length 12
1068
1069 Name = 销售部134
1070
1071 Slot 28 Column 4 Offset 0x47 Length 6
1072
1073 GroupName = 销售组
1074
1075 Slot 28 Column 5 Offset 0x8 Length 8
1076
1077 ModifiedDate = 07 17 2013 11:04PM
1078
1079 Slot 29 Offset 0x919 Length 77
1080
1081 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1082
1083 Memory Dump @0x0A64C919
1084
1085 00000000: 30001000 87000000 d52e7c01 fea10000 †0.........|.....
1086 00000010: 0600c004 0021003b 0047004d 00860000 †.....!.;.G.M....
1087 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1088 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1089 00000040: 90310033 00350000 952e55c4 7e††††††††.1.3.5....U.~
1090
1091 Slot 29 Column 0 Offset 0x1d Length 4
1092
1093 UNIQUIFIER = 134
1094
1095 Slot 29 Column 1 Offset 0x21 Length 26
1096
1097 Company = 中国你好有限公司XX分公司
1098
1099 Slot 29 Column 2 Offset 0x4 Length 4
1100
1101 DepartmentID = 135
1102
1103 Slot 29 Column 3 Offset 0x3b Length 12
1104
1105 Name = 销售部135
1106
1107 Slot 29 Column 4 Offset 0x47 Length 6
1108
1109 GroupName = 销售组
1110
1111 Slot 29 Column 5 Offset 0x8 Length 8
1112
1113 ModifiedDate = 07 17 2013 11:04PM
1114
1115 Slot 30 Offset 0x966 Length 77
1116
1117 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1118
1119 Memory Dump @0x0A64C966
1120
1121 00000000: 30001000 88000000 d62e7c01 fea10000 †0.........|.....
1122 00000010: 0600c004 0021003b 0047004d 00870000 †.....!.;.G.M....
1123 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1124 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1125 00000040: 90310033 00360000 952e55c4 7e††††††††.1.3.6....U.~
1126
1127 Slot 30 Column 0 Offset 0x1d Length 4
1128
1129 UNIQUIFIER = 135
1130
1131 Slot 30 Column 1 Offset 0x21 Length 26
1132
1133 Company = 中国你好有限公司XX分公司
1134
1135 Slot 30 Column 2 Offset 0x4 Length 4
1136
1137 DepartmentID = 136
1138
1139 Slot 30 Column 3 Offset 0x3b Length 12
1140
1141 Name = 销售部136
1142
1143 Slot 30 Column 4 Offset 0x47 Length 6
1144
1145 GroupName = 销售组
1146
1147 Slot 30 Column 5 Offset 0x8 Length 8
1148
1149 ModifiedDate = 07 17 2013 11:04PM
1150
1151 Slot 31 Offset 0x9b3 Length 77
1152
1153 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1154
1155 Memory Dump @0x0A64C9B3
1156
1157 00000000: 30001000 89000000 d62e7c01 fea10000 †0.........|.....
1158 00000010: 0600c004 0021003b 0047004d 00880000 †.....!.;.G.M....
1159 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1160 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1161 00000040: 90310033 00370000 952e55c4 7e††††††††.1.3.7....U.~
1162
1163 Slot 31 Column 0 Offset 0x1d Length 4
1164
1165 UNIQUIFIER = 136
1166
1167 Slot 31 Column 1 Offset 0x21 Length 26
1168
1169 Company = 中国你好有限公司XX分公司
1170
1171 Slot 31 Column 2 Offset 0x4 Length 4
1172
1173 DepartmentID = 137
1174
1175 Slot 31 Column 3 Offset 0x3b Length 12
1176
1177 Name = 销售部137
1178
1179 Slot 31 Column 4 Offset 0x47 Length 6
1180
1181 GroupName = 销售组
1182
1183 Slot 31 Column 5 Offset 0x8 Length 8
1184
1185 ModifiedDate = 07 17 2013 11:04PM
1186
1187 Slot 32 Offset 0xa00 Length 77
1188
1189 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1190
1191 Memory Dump @0x0A64CA00
1192
1193 00000000: 30001000 8a000000 d62e7c01 fea10000 †0.........|.....
1194 00000010: 0600c004 0021003b 0047004d 00890000 †.....!.;.G.M....
1195 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1196 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1197 00000040: 90310033 00380000 952e55c4 7e††††††††.1.3.8....U.~
1198
1199 Slot 32 Column 0 Offset 0x1d Length 4
1200
1201 UNIQUIFIER = 137
1202
1203 Slot 32 Column 1 Offset 0x21 Length 26
1204
1205 Company = 中国你好有限公司XX分公司
1206
1207 Slot 32 Column 2 Offset 0x4 Length 4
1208
1209 DepartmentID = 138
1210
1211 Slot 32 Column 3 Offset 0x3b Length 12
1212
1213 Name = 销售部138
1214
1215 Slot 32 Column 4 Offset 0x47 Length 6
1216
1217 GroupName = 销售组
1218
1219 Slot 32 Column 5 Offset 0x8 Length 8
1220
1221 ModifiedDate = 07 17 2013 11:04PM
1222
1223 Slot 33 Offset 0xa4d Length 77
1224
1225 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1226
1227 Memory Dump @0x0A64CA4D
1228
1229 00000000: 30001000 8b000000 d62e7c01 fea10000 †0.........|.....
1230 00000010: 0600c004 0021003b 0047004d 008a0000 †.....!.;.G.M....
1231 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1232 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1233 00000040: 90310033 00390000 952e55c4 7e††††††††.1.3.9....U.~
1234
1235 Slot 33 Column 0 Offset 0x1d Length 4
1236
1237 UNIQUIFIER = 138
1238
1239 Slot 33 Column 1 Offset 0x21 Length 26
1240
1241 Company = 中国你好有限公司XX分公司
1242
1243 Slot 33 Column 2 Offset 0x4 Length 4
1244
1245 DepartmentID = 139
1246
1247 Slot 33 Column 3 Offset 0x3b Length 12
1248
1249 Name = 销售部139
1250
1251 Slot 33 Column 4 Offset 0x47 Length 6
1252
1253 GroupName = 销售组
1254
1255 Slot 33 Column 5 Offset 0x8 Length 8
1256
1257 ModifiedDate = 07 17 2013 11:04PM
1258
1259 Slot 34 Offset 0xa9a Length 77
1260
1261 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1262
1263 Memory Dump @0x0A64CA9A
1264
1265 00000000: 30001000 8c000000 d62e7c01 fea10000 †0.........|.....
1266 00000010: 0600c004 0021003b 0047004d 008b0000 †.....!.;.G.M....
1267 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1268 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1269 00000040: 90310034 00300000 952e55c4 7e††††††††.1.4.0....U.~
1270
1271 Slot 34 Column 0 Offset 0x1d Length 4
1272
1273 UNIQUIFIER = 139
1274
1275 Slot 34 Column 1 Offset 0x21 Length 26
1276
1277 Company = 中国你好有限公司XX分公司
1278
1279 Slot 34 Column 2 Offset 0x4 Length 4
1280
1281 DepartmentID = 140
1282
1283 Slot 34 Column 3 Offset 0x3b Length 12
1284
1285 Name = 销售部140
1286
1287 Slot 34 Column 4 Offset 0x47 Length 6
1288
1289 GroupName = 销售组
1290
1291 Slot 34 Column 5 Offset 0x8 Length 8
1292
1293 ModifiedDate = 07 17 2013 11:04PM
1294
1295 Slot 35 Offset 0xae7 Length 77
1296
1297 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1298
1299 Memory Dump @0x0A64CAE7
1300
1301 00000000: 30001000 8d000000 d62e7c01 fea10000 †0.........|.....
1302 00000010: 0600c004 0021003b 0047004d 008c0000 †.....!.;.G.M....
1303 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1304 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1305 00000040: 90310034 00310000 952e55c4 7e††††††††.1.4.1....U.~
1306
1307 Slot 35 Column 0 Offset 0x1d Length 4
1308
1309 UNIQUIFIER = 140
1310
1311 Slot 35 Column 1 Offset 0x21 Length 26
1312
1313 Company = 中国你好有限公司XX分公司
1314
1315 Slot 35 Column 2 Offset 0x4 Length 4
1316
1317 DepartmentID = 141
1318
1319 Slot 35 Column 3 Offset 0x3b Length 12
1320
1321 Name = 销售部141
1322
1323 Slot 35 Column 4 Offset 0x47 Length 6
1324
1325 GroupName = 销售组
1326
1327 Slot 35 Column 5 Offset 0x8 Length 8
1328
1329 ModifiedDate = 07 17 2013 11:04PM
1330
1331 Slot 36 Offset 0xb34 Length 77
1332
1333 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1334
1335 Memory Dump @0x0A64CB34
1336
1337 00000000: 30001000 8e000000 d62e7c01 fea10000 †0.........|.....
1338 00000010: 0600c004 0021003b 0047004d 008d0000 †.....!.;.G.M....
1339 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1340 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1341 00000040: 90310034 00320000 952e55c4 7e††††††††.1.4.2....U.~
1342
1343 Slot 36 Column 0 Offset 0x1d Length 4
1344
1345 UNIQUIFIER = 141
1346
1347 Slot 36 Column 1 Offset 0x21 Length 26
1348
1349 Company = 中国你好有限公司XX分公司
1350
1351 Slot 36 Column 2 Offset 0x4 Length 4
1352
1353 DepartmentID = 142
1354
1355 Slot 36 Column 3 Offset 0x3b Length 12
1356
1357 Name = 销售部142
1358
1359 Slot 36 Column 4 Offset 0x47 Length 6
1360
1361 GroupName = 销售组
1362
1363 Slot 36 Column 5 Offset 0x8 Length 8
1364
1365 ModifiedDate = 07 17 2013 11:04PM
1366
1367 Slot 37 Offset 0xb81 Length 77
1368
1369 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1370
1371 Memory Dump @0x0A64CB81
1372
1373 00000000: 30001000 8f000000 d62e7c01 fea10000 †0.........|.....
1374 00000010: 0600c004 0021003b 0047004d 008e0000 †.....!.;.G.M....
1375 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1376 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1377 00000040: 90310034 00330000 952e55c4 7e††††††††.1.4.3....U.~
1378
1379 Slot 37 Column 0 Offset 0x1d Length 4
1380
1381 UNIQUIFIER = 142
1382
1383 Slot 37 Column 1 Offset 0x21 Length 26
1384
1385 Company = 中国你好有限公司XX分公司
1386
1387 Slot 37 Column 2 Offset 0x4 Length 4
1388
1389 DepartmentID = 143
1390
1391 Slot 37 Column 3 Offset 0x3b Length 12
1392
1393 Name = 销售部143
1394
1395 Slot 37 Column 4 Offset 0x47 Length 6
1396
1397 GroupName = 销售组
1398
1399 Slot 37 Column 5 Offset 0x8 Length 8
1400
1401 ModifiedDate = 07 17 2013 11:04PM
1402
1403 Slot 38 Offset 0xbce Length 77
1404
1405 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1406
1407 Memory Dump @0x0A64CBCE
1408
1409 00000000: 30001000 90000000 d62e7c01 fea10000 †0.........|.....
1410 00000010: 0600c004 0021003b 0047004d 008f0000 †.....!.;.G.M....
1411 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1412 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1413 00000040: 90310034 00340000 952e55c4 7e††††††††.1.4.4....U.~
1414
1415 Slot 38 Column 0 Offset 0x1d Length 4
1416
1417 UNIQUIFIER = 143
1418
1419 Slot 38 Column 1 Offset 0x21 Length 26
1420
1421 Company = 中国你好有限公司XX分公司
1422
1423 Slot 38 Column 2 Offset 0x4 Length 4
1424
1425 DepartmentID = 144
1426
1427 Slot 38 Column 3 Offset 0x3b Length 12
1428
1429 Name = 销售部144
1430
1431 Slot 38 Column 4 Offset 0x47 Length 6
1432
1433 GroupName = 销售组
1434
1435 Slot 38 Column 5 Offset 0x8 Length 8
1436
1437 ModifiedDate = 07 17 2013 11:04PM
1438
1439 Slot 39 Offset 0xc1b Length 77
1440
1441 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1442
1443 Memory Dump @0x0A64CC1B
1444
1445 00000000: 30001000 91000000 d62e7c01 fea10000 †0.........|.....
1446 00000010: 0600c004 0021003b 0047004d 00900000 †.....!.;.G.M....
1447 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1448 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1449 00000040: 90310034 00350000 952e55c4 7e††††††††.1.4.5....U.~
1450
1451 Slot 39 Column 0 Offset 0x1d Length 4
1452
1453 UNIQUIFIER = 144
1454
1455 Slot 39 Column 1 Offset 0x21 Length 26
1456
1457 Company = 中国你好有限公司XX分公司
1458
1459 Slot 39 Column 2 Offset 0x4 Length 4
1460
1461 DepartmentID = 145
1462
1463 Slot 39 Column 3 Offset 0x3b Length 12
1464
1465 Name = 销售部145
1466
1467 Slot 39 Column 4 Offset 0x47 Length 6
1468
1469 GroupName = 销售组
1470
1471 Slot 39 Column 5 Offset 0x8 Length 8
1472
1473 ModifiedDate = 07 17 2013 11:04PM
1474
1475 Slot 40 Offset 0xc68 Length 77
1476
1477 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1478
1479 Memory Dump @0x0A64CC68
1480
1481 00000000: 30001000 92000000 d62e7c01 fea10000 †0.........|.....
1482 00000010: 0600c004 0021003b 0047004d 00910000 †.....!.;.G.M....
1483 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1484 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1485 00000040: 90310034 00360000 952e55c4 7e††††††††.1.4.6....U.~
1486
1487 Slot 40 Column 0 Offset 0x1d Length 4
1488
1489 UNIQUIFIER = 145
1490
1491 Slot 40 Column 1 Offset 0x21 Length 26
1492
1493 Company = 中国你好有限公司XX分公司
1494
1495 Slot 40 Column 2 Offset 0x4 Length 4
1496
1497 DepartmentID = 146
1498
1499 Slot 40 Column 3 Offset 0x3b Length 12
1500
1501 Name = 销售部146
1502
1503 Slot 40 Column 4 Offset 0x47 Length 6
1504
1505 GroupName = 销售组
1506
1507 Slot 40 Column 5 Offset 0x8 Length 8
1508
1509 ModifiedDate = 07 17 2013 11:04PM
1510
1511 Slot 41 Offset 0xcb5 Length 77
1512
1513 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1514
1515 Memory Dump @0x0A64CCB5
1516
1517 00000000: 30001000 93000000 d62e7c01 fea10000 †0.........|.....
1518 00000010: 0600c004 0021003b 0047004d 00920000 †.....!.;.G.M....
1519 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1520 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1521 00000040: 90310034 00370000 952e55c4 7e††††††††.1.4.7....U.~
1522
1523 Slot 41 Column 0 Offset 0x1d Length 4
1524
1525 UNIQUIFIER = 146
1526
1527 Slot 41 Column 1 Offset 0x21 Length 26
1528
1529 Company = 中国你好有限公司XX分公司
1530
1531 Slot 41 Column 2 Offset 0x4 Length 4
1532
1533 DepartmentID = 147
1534
1535 Slot 41 Column 3 Offset 0x3b Length 12
1536
1537 Name = 销售部147
1538
1539 Slot 41 Column 4 Offset 0x47 Length 6
1540
1541 GroupName = 销售组
1542
1543 Slot 41 Column 5 Offset 0x8 Length 8
1544
1545 ModifiedDate = 07 17 2013 11:04PM
1546
1547 Slot 42 Offset 0xd02 Length 77
1548
1549 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1550
1551 Memory Dump @0x0A64CD02
1552
1553 00000000: 30001000 94000000 d62e7c01 fea10000 †0.........|.....
1554 00000010: 0600c004 0021003b 0047004d 00930000 †.....!.;.G.M....
1555 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1556 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1557 00000040: 90310034 00380000 952e55c4 7e††††††††.1.4.8....U.~
1558
1559 Slot 42 Column 0 Offset 0x1d Length 4
1560
1561 UNIQUIFIER = 147
1562
1563 Slot 42 Column 1 Offset 0x21 Length 26
1564
1565 Company = 中国你好有限公司XX分公司
1566
1567 Slot 42 Column 2 Offset 0x4 Length 4
1568
1569 DepartmentID = 148
1570
1571 Slot 42 Column 3 Offset 0x3b Length 12
1572
1573 Name = 销售部148
1574
1575 Slot 42 Column 4 Offset 0x47 Length 6
1576
1577 GroupName = 销售组
1578
1579 Slot 42 Column 5 Offset 0x8 Length 8
1580
1581 ModifiedDate = 07 17 2013 11:04PM
1582
1583 Slot 43 Offset 0xd4f Length 77
1584
1585 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1586
1587 Memory Dump @0x0A64CD4F
1588
1589 00000000: 30001000 95000000 d62e7c01 fea10000 †0.........|.....
1590 00000010: 0600c004 0021003b 0047004d 00940000 †.....!.;.G.M....
1591 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1592 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1593 00000040: 90310034 00390000 952e55c4 7e††††††††.1.4.9....U.~
1594
1595 Slot 43 Column 0 Offset 0x1d Length 4
1596
1597 UNIQUIFIER = 148
1598
1599 Slot 43 Column 1 Offset 0x21 Length 26
1600
1601 Company = 中国你好有限公司XX分公司
1602
1603 Slot 43 Column 2 Offset 0x4 Length 4
1604
1605 DepartmentID = 149
1606
1607 Slot 43 Column 3 Offset 0x3b Length 12
1608
1609 Name = 销售部149
1610
1611 Slot 43 Column 4 Offset 0x47 Length 6
1612
1613 GroupName = 销售组
1614
1615 Slot 43 Column 5 Offset 0x8 Length 8
1616
1617 ModifiedDate = 07 17 2013 11:04PM
1618
1619 Slot 44 Offset 0xd9c Length 77
1620
1621 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1622
1623 Memory Dump @0x0A64CD9C
1624
1625 00000000: 30001000 96000000 d62e7c01 fea10000 †0.........|.....
1626 00000010: 0600c004 0021003b 0047004d 00950000 †.....!.;.G.M....
1627 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1628 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1629 00000040: 90310035 00300000 952e55c4 7e††††††††.1.5.0....U.~
1630
1631 Slot 44 Column 0 Offset 0x1d Length 4
1632
1633 UNIQUIFIER = 149
1634
1635 Slot 44 Column 1 Offset 0x21 Length 26
1636
1637 Company = 中国你好有限公司XX分公司
1638
1639 Slot 44 Column 2 Offset 0x4 Length 4
1640
1641 DepartmentID = 150
1642
1643 Slot 44 Column 3 Offset 0x3b Length 12
1644
1645 Name = 销售部150
1646
1647 Slot 44 Column 4 Offset 0x47 Length 6
1648
1649 GroupName = 销售组
1650
1651 Slot 44 Column 5 Offset 0x8 Length 8
1652
1653 ModifiedDate = 07 17 2013 11:04PM
1654
1655 Slot 45 Offset 0xde9 Length 77
1656
1657 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1658
1659 Memory Dump @0x0A64CDE9
1660
1661 00000000: 30001000 97000000 d72e7c01 fea10000 †0.........|.....
1662 00000010: 0600c004 0021003b 0047004d 00960000 †.....!.;.G.M....
1663 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1664 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1665 00000040: 90310035 00310000 952e55c4 7e††††††††.1.5.1....U.~
1666
1667 Slot 45 Column 0 Offset 0x1d Length 4
1668
1669 UNIQUIFIER = 150
1670
1671 Slot 45 Column 1 Offset 0x21 Length 26
1672
1673 Company = 中国你好有限公司XX分公司
1674
1675 Slot 45 Column 2 Offset 0x4 Length 4
1676
1677 DepartmentID = 151
1678
1679 Slot 45 Column 3 Offset 0x3b Length 12
1680
1681 Name = 销售部151
1682
1683 Slot 45 Column 4 Offset 0x47 Length 6
1684
1685 GroupName = 销售组
1686
1687 Slot 45 Column 5 Offset 0x8 Length 8
1688
1689 ModifiedDate = 07 17 2013 11:04PM
1690
1691 Slot 46 Offset 0xe36 Length 77
1692
1693 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1694
1695 Memory Dump @0x0A64CE36
1696
1697 00000000: 30001000 98000000 d72e7c01 fea10000 †0.........|.....
1698 00000010: 0600c004 0021003b 0047004d 00970000 †.....!.;.G.M....
1699 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1700 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1701 00000040: 90310035 00320000 952e55c4 7e††††††††.1.5.2....U.~
1702
1703 Slot 46 Column 0 Offset 0x1d Length 4
1704
1705 UNIQUIFIER = 151
1706
1707 Slot 46 Column 1 Offset 0x21 Length 26
1708
1709 Company = 中国你好有限公司XX分公司
1710
1711 Slot 46 Column 2 Offset 0x4 Length 4
1712
1713 DepartmentID = 152
1714
1715 Slot 46 Column 3 Offset 0x3b Length 12
1716
1717 Name = 销售部152
1718
1719 Slot 46 Column 4 Offset 0x47 Length 6
1720
1721 GroupName = 销售组
1722
1723 Slot 46 Column 5 Offset 0x8 Length 8
1724
1725 ModifiedDate = 07 17 2013 11:04PM
1726
1727 Slot 47 Offset 0xe83 Length 77
1728
1729 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1730
1731 Memory Dump @0x0A64CE83
1732
1733 00000000: 30001000 99000000 d72e7c01 fea10000 †0.........|.....
1734 00000010: 0600c004 0021003b 0047004d 00980000 †.....!.;.G.M....
1735 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1736 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1737 00000040: 90310035 00330000 952e55c4 7e††††††††.1.5.3....U.~
1738
1739 Slot 47 Column 0 Offset 0x1d Length 4
1740
1741 UNIQUIFIER = 152
1742
1743 Slot 47 Column 1 Offset 0x21 Length 26
1744
1745 Company = 中国你好有限公司XX分公司
1746
1747 Slot 47 Column 2 Offset 0x4 Length 4
1748
1749 DepartmentID = 153
1750
1751 Slot 47 Column 3 Offset 0x3b Length 12
1752
1753 Name = 销售部153
1754
1755 Slot 47 Column 4 Offset 0x47 Length 6
1756
1757 GroupName = 销售组
1758
1759 Slot 47 Column 5 Offset 0x8 Length 8
1760
1761 ModifiedDate = 07 17 2013 11:04PM
1762
1763 Slot 48 Offset 0xed0 Length 77
1764
1765 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1766
1767 Memory Dump @0x0A64CED0
1768
1769 00000000: 30001000 9a000000 d72e7c01 fea10000 †0.........|.....
1770 00000010: 0600c004 0021003b 0047004d 00990000 †.....!.;.G.M....
1771 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1772 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1773 00000040: 90310035 00340000 952e55c4 7e††††††††.1.5.4....U.~
1774
1775 Slot 48 Column 0 Offset 0x1d Length 4
1776
1777 UNIQUIFIER = 153
1778
1779 Slot 48 Column 1 Offset 0x21 Length 26
1780
1781 Company = 中国你好有限公司XX分公司
1782
1783 Slot 48 Column 2 Offset 0x4 Length 4
1784
1785 DepartmentID = 154
1786
1787 Slot 48 Column 3 Offset 0x3b Length 12
1788
1789 Name = 销售部154
1790
1791 Slot 48 Column 4 Offset 0x47 Length 6
1792
1793 GroupName = 销售组
1794
1795 Slot 48 Column 5 Offset 0x8 Length 8
1796
1797 ModifiedDate = 07 17 2013 11:04PM
1798
1799 Slot 49 Offset 0xf1d Length 77
1800
1801 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1802
1803 Memory Dump @0x0A64CF1D
1804
1805 00000000: 30001000 9b000000 d72e7c01 fea10000 †0.........|.....
1806 00000010: 0600c004 0021003b 0047004d 009a0000 †.....!.;.G.M....
1807 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1808 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1809 00000040: 90310035 00350000 952e55c4 7e††††††††.1.5.5....U.~
1810
1811 Slot 49 Column 0 Offset 0x1d Length 4
1812
1813 UNIQUIFIER = 154
1814
1815 Slot 49 Column 1 Offset 0x21 Length 26
1816
1817 Company = 中国你好有限公司XX分公司
1818
1819 Slot 49 Column 2 Offset 0x4 Length 4
1820
1821 DepartmentID = 155
1822
1823 Slot 49 Column 3 Offset 0x3b Length 12
1824
1825 Name = 销售部155
1826
1827 Slot 49 Column 4 Offset 0x47 Length 6
1828
1829 GroupName = 销售组
1830
1831 Slot 49 Column 5 Offset 0x8 Length 8
1832
1833 ModifiedDate = 07 17 2013 11:04PM
1834
1835 Slot 50 Offset 0xf6a Length 77
1836
1837 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1838
1839 Memory Dump @0x0A64CF6A
1840
1841 00000000: 30001000 9c000000 d72e7c01 fea10000 †0.........|.....
1842 00000010: 0600c004 0021003b 0047004d 009b0000 †.....!.;.G.M....
1843 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1844 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1845 00000040: 90310035 00360000 952e55c4 7e††††††††.1.5.6....U.~
1846
1847 Slot 50 Column 0 Offset 0x1d Length 4
1848
1849 UNIQUIFIER = 155
1850
1851 Slot 50 Column 1 Offset 0x21 Length 26
1852
1853 Company = 中国你好有限公司XX分公司
1854
1855 Slot 50 Column 2 Offset 0x4 Length 4
1856
1857 DepartmentID = 156
1858
1859 Slot 50 Column 3 Offset 0x3b Length 12
1860
1861 Name = 销售部156
1862
1863 Slot 50 Column 4 Offset 0x47 Length 6
1864
1865 GroupName = 销售组
1866
1867 Slot 50 Column 5 Offset 0x8 Length 8
1868
1869 ModifiedDate = 07 17 2013 11:04PM
1870
1871 Slot 51 Offset 0xfb7 Length 77
1872
1873 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1874
1875 Memory Dump @0x0A64CFB7
1876
1877 00000000: 30001000 9d000000 d72e7c01 fea10000 †0.........|.....
1878 00000010: 0600c004 0021003b 0047004d 009c0000 †.....!.;.G.M....
1879 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1880 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1881 00000040: 90310035 00370000 952e55c4 7e††††††††.1.5.7....U.~
1882
1883 Slot 51 Column 0 Offset 0x1d Length 4
1884
1885 UNIQUIFIER = 156
1886
1887 Slot 51 Column 1 Offset 0x21 Length 26
1888
1889 Company = 中国你好有限公司XX分公司
1890
1891 Slot 51 Column 2 Offset 0x4 Length 4
1892
1893 DepartmentID = 157
1894
1895 Slot 51 Column 3 Offset 0x3b Length 12
1896
1897 Name = 销售部157
1898
1899 Slot 51 Column 4 Offset 0x47 Length 6
1900
1901 GroupName = 销售组
1902
1903 Slot 51 Column 5 Offset 0x8 Length 8
1904
1905 ModifiedDate = 07 17 2013 11:04PM
1906
1907 Slot 52 Offset 0x1004 Length 77
1908
1909 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1910
1911 Memory Dump @0x0A64D004
1912
1913 00000000: 30001000 9e000000 d72e7c01 fea10000 †0.........|.....
1914 00000010: 0600c004 0021003b 0047004d 009d0000 †.....!.;.G.M....
1915 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1916 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1917 00000040: 90310035 00380000 952e55c4 7e††††††††.1.5.8....U.~
1918
1919 Slot 52 Column 0 Offset 0x1d Length 4
1920
1921 UNIQUIFIER = 157
1922
1923 Slot 52 Column 1 Offset 0x21 Length 26
1924
1925 Company = 中国你好有限公司XX分公司
1926
1927 Slot 52 Column 2 Offset 0x4 Length 4
1928
1929 DepartmentID = 158
1930
1931 Slot 52 Column 3 Offset 0x3b Length 12
1932
1933 Name = 销售部158
1934
1935 Slot 52 Column 4 Offset 0x47 Length 6
1936
1937 GroupName = 销售组
1938
1939 Slot 52 Column 5 Offset 0x8 Length 8
1940
1941 ModifiedDate = 07 17 2013 11:04PM
1942
1943 Slot 53 Offset 0x1051 Length 77
1944
1945 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1946
1947 Memory Dump @0x0A64D051
1948
1949 00000000: 30001000 9f000000 d72e7c01 fea10000 †0.........|.....
1950 00000010: 0600c004 0021003b 0047004d 009e0000 †.....!.;.G.M....
1951 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1952 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1953 00000040: 90310035 00390000 952e55c4 7e††††††††.1.5.9....U.~
1954
1955 Slot 53 Column 0 Offset 0x1d Length 4
1956
1957 UNIQUIFIER = 158
1958
1959 Slot 53 Column 1 Offset 0x21 Length 26
1960
1961 Company = 中国你好有限公司XX分公司
1962
1963 Slot 53 Column 2 Offset 0x4 Length 4
1964
1965 DepartmentID = 159
1966
1967 Slot 53 Column 3 Offset 0x3b Length 12
1968
1969 Name = 销售部159
1970
1971 Slot 53 Column 4 Offset 0x47 Length 6
1972
1973 GroupName = 销售组
1974
1975 Slot 53 Column 5 Offset 0x8 Length 8
1976
1977 ModifiedDate = 07 17 2013 11:04PM
1978
1979 Slot 54 Offset 0x109e Length 77
1980
1981 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
1982
1983 Memory Dump @0x0A64D09E
1984
1985 00000000: 30001000 a0000000 d72e7c01 fea10000 †0.........|.....
1986 00000010: 0600c004 0021003b 0047004d 009f0000 †.....!.;.G.M....
1987 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
1988 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
1989 00000040: 90310036 00300000 952e55c4 7e††††††††.1.6.0....U.~
1990
1991 Slot 54 Column 0 Offset 0x1d Length 4
1992
1993 UNIQUIFIER = 159
1994
1995 Slot 54 Column 1 Offset 0x21 Length 26
1996
1997 Company = 中国你好有限公司XX分公司
1998
1999 Slot 54 Column 2 Offset 0x4 Length 4
2000
2001 DepartmentID = 160
2002
2003 Slot 54 Column 3 Offset 0x3b Length 12
2004
2005 Name = 销售部160
2006
2007 Slot 54 Column 4 Offset 0x47 Length 6
2008
2009 GroupName = 销售组
2010
2011 Slot 54 Column 5 Offset 0x8 Length 8
2012
2013 ModifiedDate = 07 17 2013 11:04PM
2014
2015 Slot 55 Offset 0x10eb Length 77
2016
2017 Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
2018
2019 Memory Dump @0x0A64D0EB
2020
2021 00000000: 30001000 a1000000 d72e7c01 fea10000 †0.........|.....
2022 00000010: 0600c004 0021003b 0047004d 00a00000 †.....!.;.G.M....
2023 00000020: 002d4efd 56604f7d 59096750 966c51f8 †.-N.V`O}Y.gP.lQ.
2024 00000030: 53580058 0006526c 51f85300 952e55e8 †SX.X..RlQ.S...U.
2025 00000040: 90310036 00310000 952e55c4 7e††††††††.1.6.1....U.~
2026
2027 Slot 55 Column 0 Offset 0x1d Length 4
2028
2029 UNIQUIFIER = 160
View Code
还有增加了UNIQUIFIER 列之后,无论索引页和数据页都会有所增加,性能有所损耗
下面截图右边的是数据页pageid:14517中的数据,左边的是聚集索引页面
至于性能损耗多少,可以看一下宋大侠这篇文章:
----------------------------------------------------华丽的分割线-------------------------------------------------------
堆表中的数据页之间[PrevPagePID],[NextPagePID]是否会首尾相连
堆表
聚集索引表
-----------------------------------------------------华丽的分割线-------------------------------------------------
聚集索引有一个特点,就是当表记录太少的时候,可能一个数据页面就能容纳下表的所有记录,那么这时候由于可能只有一个页面不足以构成一棵B树
创建Department6表,然后插入9条记录
1 --只有聚集索引
2 USE [pratice]
3 GO
4 CREATE TABLE Department6
5 (
6 DepartmentID INT IDENTITY(1, 1) NOT NULL ,
7 Name NVARCHAR(200) NOT NULL ,
8 GroupName NVARCHAR(200) NOT NULL ,
9 Company NVARCHAR(300) ,
10 ModifiedDate DATETIME NOT NULL DEFAULT ( GETDATE() ) ,
11 CONSTRAINT [PK_Department6_1] PRIMARY KEY CLUSTERED
12 ( Name ASC,DepartmentID ASC )
13 WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
14 ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
15 ) ON [PRIMARY]
16
17
18 DECLARE @i INT
19 SET @i=1
20 WHILE @i < 10
21 BEGIN
22 INSERT INTO Department6 ( name, [Company], groupname )
23 VALUES ( '销售部'+CAST(@i AS VARCHAR(200)), '中国你好有限公司XX分公司', '销售组' )
24 SET @i = @i + 1
25 END
只有一个数据页和一个IAM页
插入更多记录
1 DECLARE @i INT
2 SET @i=1
3 WHILE @i < 100000
4 BEGIN
5 INSERT INTO Department6 ( name, [Company], groupname )
6 VALUES ( '销售部'+CAST(@i AS VARCHAR(200)), '中国你好有限公司XX分公司', '销售组' )
7 SET @i = @i + 1
8 END
因为数据页开始多起来了,这时候聚集索引会组织会一棵有层次结构的B树
IndexLevel为2 表示这棵B树有3层
0:叶子节点层
1:非叶子节点层
2:root层
PageType 分页类型: 1:数据页面;2:索引页面;3:Lob_mixed_page;4:Lob_tree_page;10:IAM页面
IndexID 索引ID: 0 代表堆, 1 代表聚集索引, 2-250 代表非聚集索引 ,大于250就是text或image字段
---------------------------------------------华丽的分割线---------------------------------------------------
大家再看一下Department2表的那部分,究竟数据页的排序顺序跟主键DepartmentID的排序顺序有没有关系呢?
先创建Department7表,插入1000条记录
1 CREATE TABLE Department7(
2 DepartmentID int IDENTITY(1,1) NOT NULL PRIMARY KEY,
3 Name NVARCHAR(200) NOT NULL,
4 GroupName NVARCHAR(200) NOT NULL,
5 Company NVARCHAR(300),
6 ModifiedDate datetime NOT NULL DEFAULT (getdate())
7 )
8
9 INSERT INTO Department7(name,[Company],groupname) VALUES('销售部','中国你好有限公司XX分公司','销售组')
10 GO 1000
11
12 SELECT * FROM Department7
View Code
1 --TRUNCATE TABLE [dbo].[DBCCResult]
2 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department7,-1) ')
3
4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
根据数据页的首尾连接顺序,我画了一下草图
看一下索引页13791
1 DBCC TRACEON(3604,-1)
2 GO
3
4 DBCC PAGE([pratice],1,13791,3)
5 GO
View Code
再画一下草图
对比一下数据页的首尾连接顺序那张图,不知道大家看出规律没有
所以我把聚集索引结构图画成下面这个样子
为什麽聚集索引只能按照第一个字段生成key?为什麽数据页只能按照第一个字段来排序?
其实这个跟数据页排序有关的,大家再仔细看下面两张图
聚集索引页里根据第一个字段排列好这些数据页的第一个字段的范围值,数据页根据这个范围值首尾相连一一排序好
如果聚集索引按多个字段来排序,那么数据页根本排不了,多个字段又升序,又降序??那怎么排序啊?只能按照一个字段来排序
聚集索引查找的时候,使用order by为什麽这么快,因为数据已经根据索引第一个字段排好序了,例子中的字段就是DepartmentID
而只有非聚集索引的表order by的时候就需要排一下序了,因为表中没有聚集索引,数据页没有预先按照一定顺序来排序
详细可以看一下非聚集索引的结构:SQLSERVER聚集索引与非聚集索引的再次研究(下)
---------------------------------------------华丽的分割线--------------------------------------------------------
问题:为什么一个表只能建立一个聚集索引
其实大家看一下我上面画的聚集索引结构图和非聚集索引结构图就知道了
因为如果一个表有聚集索引,那么他的数据页跟索引页有非常强的联系,数据页跟主键第一个字段排好序了,例子中就是“DepartmentID”
如果你再建一个聚集索引,你叫SQLSERVER应该按哪个字段来排序?排序方式是按照你原来的那个聚集索引的DepartmentID列来排序还是
按照你新建的那个聚集索引的第一个字段来排序??
多个聚集索引,数据页都按不同的字段顺序排序,来建立双向链表,那数据表不就乱套了???
但是如果一个表中只有非聚集索引,非聚集索引里的索引页的每一行会有一个指针值指向数据页,数据页依然是堆,没有任何顺序可言
所以你可以在一个表上建立多个非聚集索引也没问题
至于表里面只有非聚集索引表结构是怎样的,大家可以看一下本系列的《SQLSERVER聚集索引与非聚集索引的再次研究(下)》
到时大家就会更加清楚了o(∩_∩)o
----------------------------------------------华丽的分割线----------------------------------------------------------
还有一个问题没有解决:
为什麽根节点只有两行???是不是根节点只作连接作用,所以只有两行 ?
聚集索引就说到这里了,有些地方有可能不对,希望大家强烈拍砖o(∩_∩)o
也希望给个推荐o(∩_∩)o
---------------------------------------------------------------------------
2013-7-21补充
为什麽根节点只有两行??其实根节点不只有两行的
由于出现二层索引节点需要插入大量数据,如果数据很少的话索引节点只有一层,并且不能用主键,只能创建聚集索引
根据宋大侠说的,当页拆分的时候,根节点就会增加记录,我这里提供一下脚本
1 USE [pratice]
2 GO
3 --------------------------------------------------------------------
4 --只有聚集索引
5 --DROP TABLE [dbo].[Department]
6 CREATE TABLE Department(
7 DepartmentID int NOT NULL ,
8 Name NVARCHAR(200) NOT NULL,
9 GroupName NVARCHAR(200) NOT NULL,
10 Company NVARCHAR(300),
11 ModifiedDate datetime NOT NULL DEFAULT (getdate())
12 )
13
14 CREATE CLUSTERED INDEX CL_DepartmentID ON Department(DepartmentID ASC)
15
16 DECLARE @i INT
17 SET @i=1
18 WHILE @i < 300000
19 BEGIN
20 INSERT INTO Department([DepartmentID], name, [Company], groupname )
21 VALUES ( @i,'销售部'+CAST(@i AS VARCHAR(200)), '中国你好有限公司XX分公司', '销售组'+CAST(@i AS VARCHAR(200)) )
22 SET @i = @i + 3
23 END
24
25 --DROP TABLE Department
26 SELECT * FROM Department
27
28
29
30 --TRUNCATE TABLE [dbo].[DBCCResult]
31 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,Department,-1) ')
32
33 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
大家可以测试一下
插入数据的时候最好是根节点前的记录
附上宋大侠的文章:
T-SQL查询高级—SQL Server索引中的碎片和填充因子
根节点的记录行数在下面两种情况下会有所变化
(1)向表中插入数据或更新表中数据并产生碎片的时候
(2)碎片很多然后alter index REORGANIZE 重组索引的时候
1 ALTER INDEX [dbo].[TableForTest].[CIX] ON [dbo].[Department] REORGANIZE
------------------------------------------------------------------------------
2013-8-24 补充:
关于我在文中说的
至于应不应该在重复值很多的列上建立聚集索引我这里也不敢妄下判断,因为实际环境和这里的测试环境不一样
今天看了一下《SQLSERVER企业级平台管理实践》,书里面第437页是这样说的
要慎重选择索引的第一个字段,最好选择一个重复记录最少的字段。这是因为索引上的统计信息只保存第一个字段的数据直方图。如果选择一个
重复数据很多的字段,这个索引的可选度就比较低了,会影响索引的价值
所以,为什麽建立聚集索引的时候,只能在一个字段上建立索引,并且这个字段最好不要重复,从数据直方图上也能解释这个原因
------------------------------------------------------------------------------------------
2013-9-15 补充:
如何查看聚集索引页面的内容,使用DBCC PAGE的时候使用1这个格式就可以了
聚集索引页中有三条记录,而且三条记录的Record Type = INDEX_RECORD
1 DBCC TRACEON(3604,-1)
2 GO
3 DBCC PAGE([pratice],1,37397,1)
4 GO
1 DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。
2
3 PAGE: (1:37397)
4
5
6 BUFFER:
7
8
9 BUF @0x03E5DC3C
10
11 bpage = 0x1A8D8000 bhash = 0x00000000 bpageno = (1:37397)
12 bdbid = 5 breferences = 0 bUse1 = 6487
13 bstat = 0x3c0000b blog = 0x212159bb bnext = 0x00000000
14
15 PAGE HEADER:
16
17
18 Page @0x1A8D8000
19
20 m_pageId = (1:37397) m_headerVersion = 1 m_type = 2
21 m_typeFlagBits = 0x0 m_level = 1 m_flagBits = 0x0
22 m_objId (AllocUnitId.idObj) = 549 m_indexId (AllocUnitId.idInd) = 256
23 Metadata: AllocUnitId = 72057594073907200
24 Metadata: PartitionId = 72057594061717504 Metadata: IndexId = 1
25 Metadata: ObjectId = 1543676547 m_prevPage = (0:0) m_nextPage = (0:0)
26 pminlen = 11 m_slotCnt = 3 m_freeCnt = 8057
27 m_freeData = 129 m_reservedCnt = 0 m_lsn = (3046:261:41)
28 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
29 m_tornBits = 0
30
31 Allocation Status
32
33 GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED
34 PFS (1:32352) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
35 ML (1:7) = NOT MIN_LOGGED
36
37 DATA:
38
39
40 Slot 0, Offset 0x60, Length 11, DumpStyle BYTE
41
42 Record Type = INDEX_RECORD Record Attributes =
43 Memory Dump @0x0A3BC060
44
45 00000000: 06010000 00283d00 000100†††††††††††††.....(=....
46
47 Slot 1, Offset 0x6b, Length 11, DumpStyle BYTE
48
49 Record Type = INDEX_RECORD Record Attributes =
50 Memory Dump @0x0A3BC06B
51
52 00000000: 06950100 00929100 000100†††††††††††††...........
53
54 Slot 2, Offset 0x76, Length 11, DumpStyle BYTE
55
56 Record Type = INDEX_RECORD Record Attributes =
57 Memory Dump @0x0A3BC076
58
59 00000000: 06290300 002f0000 000100†††††††††††††.).../.....
60
61 OFFSET TABLE:
62
63 Row - Offset
64 2 (0x2) - 118 (0x76)
65 1 (0x1) - 107 (0x6b)
66 0 (0x0) - 96 (0x60)
67
68
69 DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。