剖析SQLSERVER2005的页面结构--行类型篇一

--------------------------------------------------------------------- -- Author : HappyFlyStone -- Date : 2009-11-30 -- Version: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) -- Apr 14 2006 01:12:25 -- Copyright (c) 1988-2005 Micros

---------------------------------------------------------------------

-- Author : HappyFlyStone

-- Date : 2009-11-30

-- Version: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

-- Apr 14 2006 01:12:25

-- Copyright (c) 1988-2005 Microsoft Corporation

-- Enterprise Edition on Windows NT 5.2 (Build 3790: SP2)

--

---------------------------------------------------------------------

CREATE PROC sp_us_FPSinfo

@FORWARDING_STUB BINARY(8)

AS

SELECT

CAST(

CONVERT(INT,SUBSTRING(@FORWARDING_STUB,6,1)) * POWER(2,8)

+ CONVERT(INT,SUBSTRING(@FORWARDING_STUB,5,1))

AS VARCHAR)+' : ' --File_num

+CAST(

(CONVERT(INT,SUBSTRING(@FORWARDING_STUB,4,1)) * POWER(2,24))

+ (CONVERT(INT,SUBSTRING(@FORWARDING_STUB,3,1)) * POWER(2,16))

+ (CONVERT(INT,SUBSTRING(@FORWARDING_STUB,2,1)) * POWER(2,8 ))

+ (CONVERT(INT,SUBSTRING(@FORWARDING_STUB,1,1))) AS VARCHAR)

+' : ' --Page_id

+CAST(CAST(SUBSTRING(@FORWARDING_STUB,8,1) * POWER(2,8 ) +

+ SUBSTRING(@FORWARDING_STUB,7,1) AS INT ) AS VARCHAR)

AS 'FILE_NUM:PAGE_ID:SLOT_ID'

GO

EXEC sp_us_FPSinfo 0xDD00000001000200 --

DROP PROC sp_us_FPSinfo

/*

FILE_NUM:PAGE_ID:SLOT

--------------------------

1 : 221 : 2

(1 行受影响)

*/