---------------------------------------------------------------------
-- 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 行受影响)
*/