求助：识别这些数据的规律

Question

请各位一起识别，下面这些数怎么用sql语句生成：ufts
0x000000000009AA24
0x000000000009AA25
0x000000000009AEE6
0x000000000009AEE7
0x000000000009AEE8
0x000000000009AEE9
0x000000000009AEEA
0x000000000009AEEB
0x000000000009AEEC
0x000000000009AEED
0x000000000009AEEE
0x000000000009AEEF
0x000000000009AEF0
0x000000000009AEF1
0x000000000009AEF2
0x000000000009AEF3
0x000000000009AEF4
0x000000000009AEF5
0x000000000009AEF6
0x000000000009AEF7
0x000000000009AEF8
0x000000000009AEF9
0x000000000009AEFA
0x000000000009AEFB
0x000000000009AEFC
0x000000000009AEFD
0x000000000009AEFE
0x000000000009AEFF
0x000000000009AF01
0x000000000009AF02
0x000000000009AF03
0x000000000009AF04
0x000000000009AF05
0x000000000009AF06
0x000000000009AF07
0x000000000009AF08
0x000000000009AF09
0x000000000009AF0A
0x000000000009AF0B
0x000000000009AF0C
0x000000000009AF0D
0x000000000009AF0E
0x000000000009AF0F
0x000000000009AF10
0x000000000009AF11
0x000000000009AF12
0x000000000009AF13
0x000000000009AF14
0x000000000009AF15
0x000000000009AF16
0x000000000009AF17
0x000000000009AF18
0x000000000009AF19
0x000000000009AF1A
0x000000000009AF1B
0x000000000009AF1C
0x000000000009AF1D
0x000000000009AA26
0x000000000009AA27
0x000000000009AA28
0x000000000009AA29
0x000000000009AA2A
0x000000000009AA2B
0x000000000009AA2C
0x000000000009AA2D
0x000000000009AA2E
0x000000000009AA2F
0x000000000009AA30
0x000000000009AA31
0x000000000009AA32
0x000000000009AA33
0x000000000009AA34
0x000000000009AA35
0x000000000009AA36
0x000000000009AA37
0x000000000009AA38
0x000000000009AA39
0x000000000009AA3A
0x000000000009AA3B
0x000000000009AA3C
0x000000000009AA3D
0x000000000009AA3E
0x000000000009AA3F
0x000000000009AA40
0x000000000009AA41
0x000000000009AA42
0x000000000009AA43
0x000000000009AA44
0x000000000009AA45
0x000000000009AA46
0x000000000009AA47
0x000000000009AA48
0x000000000009AA49
0x000000000009AA4A
0x000000000009AA4B
0x000000000009AA4C
0x000000000009AA4D
0x000000000009AA4E
0x000000000009AA4F
0x000000000009AA50
0x000000000009AA51
0x000000000009AA52
0x000000000009AA53
0x000000000009AA54
0x000000000009AA55
0x000000000009AA56
0x000000000009AA57
0x000000000009AA58
0x000000000009AA59
0x000000000009AA5A
0x000000000009AA5B
0x000000000009AA5C
0x000000000009AA5D
0x000000000009AA5E
0x000000000009AA5F
0x000000000009AA60
0x000000000009AA61
0x000000000009AA62
0x000000000009AA63
0x000000000009AA64
0x000000000009AA65
0x000000000009AA66
0x000000000009AA67
0x000000000009AA68
0x00000000003E31C0
0x000000000009AA6A
0x0000000000869A06
0x000000000009AA6C
0x000000000009AA6D
0x000000000009AA6E
0x000000000009AA6F
0x000000000009AA70
0x00000000001C8CF9
0x00000000000D7862
0x000000000009AA73
0x000000000009AA74
0x000000000009AA75
0x000000000009AA76
0x000000000009AA77
0x000000000009AA78
0x0000000000387384
0x000000000009AA7A
0x000000000009AA7B
0x000000000009AA7C
0x000000000009AA7D
0x000000000060521E
0x000000000009AA7F
0x000000000009AA80
0x000000000009AA81
0x000000000009AA82
0x000000000009AA83
0x000000000009AA84
0x000000000009AA85
0x000000000009AA86
0x000000000009AA87
0x000000000086017F
0x000000000009AA89
0x00000000000F072F
0x000000000086019A
0x000000000009AA8C
0x00000000000CCE1E
0x000000000009AA8E
0x000000000009AA8F
0x000000000009AA90
0x000000000009AA91
0x000000000009AA92
0x00000000001C8C4B
0x000000000009AA94
0x000000000009AA95
0x000000000009AA96
0x00000000001C8C4F
0x000000000009AA98
0x000000000009AA99
0x000000000009AA9A
0x000000000009AA9B
0x00000000000A5594
0x00000000000F071D
0x000000000009AA9E
0x00000000000F0726
0x00000000000A5567
0x0000000000604999
0x000000000009AAA2
0x000000000009AAA3
0x000000000009AAA4
0x00000000000A5597
0x00000000000A556A
0x00000000000F072C
0x0000000000375E06
0x0000000000860185
0x0000000000876579
0x000000000009AAAB
0x000000000009AAAC
0x00000000000A8EB1
0x000000000009AAAE
0x0000000000375DFF
0x00000000000A8EB4
0x00000000000A8EB7
0x000000000009AAB2
0x000000000009AAB3
0x00000000000A556D
0x000000000009AAB5
0x000000000009AAB6
0x000000000009AAB7
0x00000000000CD917
0x00000000000CF309
0x00000000000A8EBA
0x00000000000A8EEA
0x00000000003E31C3
0x00000000000F0732
0x00000000000D76C0
0x000000000009AABF
0x00000000000C4571
0x00000000000A8EED
0x00000000000A8F0F
0x00000000000A4DCE
0x000000000009AAC4
0x000000000009AAC5
0x000000000009AAC6
0x00000000000A8F12
0x000000000009AAC8
0x00000000000CCE27
0x00000000000A5579
0x0000000000860188
0x00000000000E9B7B
0x000000000009AACD
0x000000000009AACE
0x000000000009AACF
0x00000000000EA2DA
0x000000000009AAD1
0x000000000087657A
0x000000000009AAD3
0x000000000009AAD4
0x00000000000CFCA9
0x00000000000D91DB
0x00000000000E9B6C
0x00000000000C5004
0x00000000000C5028
0x00000000000EA2CE
0x000000000009AADB
0x00000000000A557C
0x000000000087666B
0x0000000000868B47
0x0000000000868B4A
0x0000000000868B3E
0x0000000000868B44
0x00000000000C5064
0x00000000000C507C
0x0000000000375DF0
0x00000000000A3813
0x000000000009AAE6
0x0000000000375486
0x000000000009AAE8
0x00000000000CF329
0x00000000000F0735
0x00000000000C507F
0x00000000000C506A
0x00000000000E9B57
0x00000000000E9B8A
0x00000000000D0389
0x00000000000C4FFA
0x0000000000868B59
0x00000000000E9D2B
0x00000000000C4FD6
0x00000000000CD93B
0x0000000000375DF3
0x00000000000C5085
0x00000000000C5073
0x00000000000C5076
0x00000000000C500D
0x00000000000F0723
0x0000000000375E09
0x00000000000A4E95
0x00000000000C4FF4
0x00000000000C4FFD
0x00000000000A4DD1
0x000000000086018B
0x00000000000C506D
0x0000000000868B4D
0x0000000000868B50
0x000000000082CCA4
0x0000000000375483
0x0000000000868B41
0x000000000082CC9D
0x00000000000CCE21
0x00000000000A557F
0x000000000009AB0B
0x00000000001C8C53
0x00000000000C4569
0x00000000000E9B6F
0x00000000000E9B8D
0x000000000086A387
0x00000000003A1659
0x0000000000868B56
0x00000000000EAF3E
0x000000000009AB14
0x00000000000C5010
0x00000000000C4FE5
0x00000000000C500A
0x00000000000C5082
0x00000000000C4FBE
0x00000000000A558E
0x00000000000E9B5D
0x000000000009AB1C
0x00000000000CD3F9
0x0000000000868B53
0x00000000000CD920
0x00000000000A3EAA
0x00000000000E9B93
0x000000000061553E
0x00000000000A5591
0x00000000000A37A6
0x00000000000E9B60
0x000000000009AB26
0x00000000003B29D8
0x0000000000375509
0x00000000003754F9
0x00000000000D91D6
0x000000000009AB2B
0x00000000003B2A63
0x00000000003C0DA7
0x00000000003B2A12
0x000000000037551B
0x00000000003B29FF
0x00000000003B29ED
0x00000000003754FC
0x000000000009AB33
0x00000000000E9D25
0x00000000000E9CF1
0x00000000000E9D07
0x0000000000387387
0x000000000038738A
0x00000000000CFC6B
0x00000000000E9BB4
0x00000000003754D2
0x00000000003B2A99
0x00000000003C0D8F
0x00000000000E9BC9
0x00000000000A4E98
0x000000000082CCF2
0x00000000000A4E9B
0x00000000003B2A1B
0x00000000003A1665
0x00000000003754F0
0x00000000000A7557
0x00000000000A8A9D
0x00000000000A5104
0x00000000000A5025
0x00000000000A500D
0x00000000000CD93E
0x00000000003B2A96
0x00000000003B2A3F
0x00000000000CFC6E
0x00000000000A8AA3
0x00000000000EA2D1
0x00000000000A7862
0x00000000000A7877
0x00000000000A787D
0x00000000003B2A42
0x00000000003B2A54
0x00000000000CFC74
0x000000000009AB56
0x00000000000D0392
0x00000000000A7560
0x00000000000E9D19
0x00000000000E9CF7
0x00000000000E9D28
0x00000000000E9CFD
0x00000000000F0738
0x00000000000D0395
0x000000000037551E
0x000000000037550F
0x00000000000E9B81
0x00000000000A378E
0x00000000000A3791
0x0000000000837C1E
0x00000000000A5013
0x00000000000A4EC5
0x00000000000E9BC0
0x0000000000375512
0x000000000037550C
0x00000000000A8AA9
0x00000000000A7575
0x00000000000A757B
0x00000000000A559D
0x000000000009AB6E
0x00000000000A7599
0x00000000008765B4
0x000000000082CC7F
0x00000000003B2A57
0x000000000082973F
0x00000000000F09BE
0x00000000000A7596
0x000000000009AB76
0x00000000003B2A9C
0x0000000000375489
0x00000000000CCE24
0x00000000000EA39A
0x00000000000A7883
0x00000000003B2A9F
0x000000000009AB7D
0x00000000000E9B63
0x00000000000CFC77
0x00000000000A75A8
0x00000000000A75B1
0x00000000000A55A0
0x00000000000E9B9F
0x0000000000375E0F
0x00000000000A75B4

Answer 1

--> 测试数据：#tb
IF OBJECT_ID('TEMPDB.DBO.#tb') IS NOT NULL DROP TABLE #tb
GO
CREATE TABLE #tb([col] INT)
INSERT #tb
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4
GO--> 测试语句：
SELECT cast( [col] as varbinary(8)) FROM #tb
/*
(无列名)
0x00000001
0x00000002
0x00000003
0x00000004
*/

Answer 2

--> 测试数据：#tb
IF OBJECT_ID('TEMPDB.DBO.#tb') IS NOT NULL DROP TABLE #tb
GO
CREATE TABLE #tb([ufts] VARBINARY(8))
INSERT #tb
SELECT 0x000000000009AA24 UNION ALL
SELECT 0x000000000009AA25 UNION ALL
SELECT 0x000000000009AEE6 UNION ALL
SELECT 0x000000000009AEE7 UNION ALL
SELECT 0x000000000009AEE8
GO--> 测试语句：
SELECT cast([ufts] as int) FROM #tb
/*
(无列名)
633380
633381
634598
634599
634600
*/

Answer 3

CREATE  function HexToInt (@hex varchar(100))
 returns int
 as
 begin
     Declare @result int,@iPos int,@iTmp int,@iLoop int,@tmp varchar(16)
     Set @tmp = '0123456789ABCDEF'
     Select @result = 0,@iPos = 0
     While @iPos <   Len(@hex)
     Begin
           Set  @iTmp = 
                CharIndex(substring(@hex,Len(@hex) - @iPos,1),@tmp)-1
           Set @iLoop = 1
           While @iLoop <= @iPos and @iTmp > 0
           begin
               Set @iTmp = @iTmp * 16
               Set @iLoop = @iLoop + 1
           end
           Set @result = @result + @iTmp
           Set @iLoop = @iLoop + 1     
           Set @iPos = @iPos + 1
     End
 
     return @result
 END
 
 
 SELECT dbo.HexToInt('0x000000000009AA24')
 /*
 
 ----------
 633379-
 
 (1 行受影响)
 
 
 */