求助：识别这些数据的规律
请各位一起识别，下面这些数怎么用sql语句生成：
ufts0x000000000009AA240x000000000009AA250x000000000009AEE60x000000000009AEE70x000000000009AEE80x000000000009AEE90x000000000009AEEA0x000000000009AEEB0x000000000009AEEC0x000000000009AEED0x000000000009AEEE0x000000000009AEEF0x000000000009AEF00x000000000009AEF10x000000000009AEF20x000000000009AEF30x000000000009AEF40x000000000009AEF50x000000000009AEF60x000000000009AEF70x000000000009AEF80x000000000009AEF90x000000000009AEFA0x000000000009AEFB0x000000000009AEFC0x000000000009AEFD0x000000000009AEFE0x000000000009AEFF0x000000000009AF010x000000000009AF020x000000000009AF030x000000000009AF040x000000000009AF050x000000000009AF060x000000000009AF070x000000000009AF080x000000000009AF090x000000000009AF0A0x000000000009AF0B0x000000000009AF0C0x000000000009AF0D0x000000000009AF0E0x000000000009AF0F0x000000000009AF100x000000000009AF110x000000000009AF120x000000000009AF130x000000000009AF140x000000000009AF150x000000000009AF160x000000000009AF170x000000000009AF180x000000000009AF190x000000000009AF1A0x000000000009AF1B0x000000000009AF1C0x000000000009AF1D0x000000000009AA260x000000000009AA270x000000000009AA280x000000000009AA290x000000000009AA2A0x000000000009AA2B0x000000000009AA2C0x000000000009AA2D0x000000000009AA2E0x000000000009AA2F0x000000000009AA300x000000000009AA310x000000000009AA320x000000000009AA330x000000000009AA340x000000000009AA350x000000000009AA360x000000000009AA370x000000000009AA380x000000000009AA390x000000000009AA3A0x000000000009AA3B0x000000000009AA3C0x000000000009AA3D0x000000000009AA3E0x000000000009AA3F0x000000000009AA400x000000000009AA410x000000000009AA420x000000000009AA430x000000000009AA440x000000000009AA450x000000000009AA460x000000000009AA470x000000000009AA480x000000000009AA490x000000000009AA4A0x000000000009AA4B0x000000000009AA4C0x000000000009AA4D0x000000000009AA4E0x000000000009AA4F0x000000000009AA500x000000000009AA510x000000000009AA520x000000000009AA530x000000000009AA540x000000000009AA550x000000000009AA560x000000000009AA570x000000000009AA580x000000000009AA590x000000000009AA5A0x000000000009AA5B0x000000000009AA5C0x000000000009AA5D0x000000000009AA5E0x000000000009AA5F0x000000000009AA600x000000000009AA610x000000000009AA620x000000000009AA630x000000000009AA640x000000000009AA650x000000000009AA660x000000000009AA670x000000000009AA680x00000000003E31C00x000000000009AA6A0x0000000000869A060x000000000009AA6C0x000000000009AA6D0x000000000009AA6E0x000000000009AA6F0x000000000009AA700x00000000001C8CF90x00000000000D78620x000000000009AA730x000000000009AA740x000000000009AA750x000000000009AA760x000000000009AA770x000000000009AA780x00000000003873840x000000000009AA7A0x000000000009AA7B0x000000000009AA7C0x000000000009AA7D0x000000000060521E0x000000000009AA7F0x000000000009AA800x000000000009AA810x000000000009AA820x000000000009AA830x000000000009AA840x000000000009AA850x000000000009AA860x000000000009AA870x000000000086017F0x000000000009AA890x00000000000F072F0x000000000086019A0x000000000009AA8C0x00000000000CCE1E0x000000000009AA8E0x000000000009AA8F0x000000000009AA900x000000000009AA910x000000000009AA920x00000000001C8C4B0x000000000009AA940x000000000009AA950x000000000009AA960x00000000001C8C4F0x000000000009AA980x000000000009AA990x000000000009AA9A0x000000000009AA9B0x00000000000A55940x00000000000F071D0x000000000009AA9E0x00000000000F07260x00000000000A55670x00000000006049990x000000000009AAA20x000000000009AAA30x000000000009AAA40x00000000000A55970x00000000000A556A0x00000000000F072C0x0000000000375E060x00000000008601850x00000000008765790x000000000009AAAB0x000000000009AAAC0x00000000000A8EB10x000000000009AAAE0x0000000000375DFF0x00000000000A8EB40x00000000000A8EB70x000000000009AAB20x000000000009AAB30x00000000000A556D0x000000000009AAB50x000000000009AAB60x000000000009AAB70x00000000000CD9170x00000000000CF3090x00000000000A8EBA0x00000000000A8EEA0x00000000003E31C30x00000000000F07320x00000000000D76C00x000000000009AABF0x00000000000C45710x00000000000A8EED0x00000000000A8F0F0x00000000000A4DCE0x000000000009AAC40x000000000009AAC50x000000000009AAC60x00000000000A8F120x000000000009AAC80x00000000000CCE270x00000000000A55790x00000000008601880x00000000000E9B7B0x000000000009AACD0x000000000009AACE0x000000000009AACF0x00000000000EA2DA0x000000000009AAD10x000000000087657A0x000000000009AAD30x000000000009AAD40x00000000000CFCA90x00000000000D91DB0x00000000000E9B6C0x00000000000C50040x00000000000C50280x00000000000EA2CE0x000000000009AADB0x00000000000A557C0x000000000087666B0x0000000000868B470x0000000000868B4A0x0000000000868B3E0x0000000000868B440x00000000000C50640x00000000000C507C0x0000000000375DF00x00000000000A38130x000000000009AAE60x00000000003754860x000000000009AAE80x00000000000CF3290x00000000000F07350x00000000000C507F0x00000000000C506A0x00000000000E9B570x00000000000E9B8A0x00000000000D03890x00000000000C4FFA0x0000000000868B590x00000000000E9D2B0x00000000000C4FD60x00000000000CD93B0x0000000000375DF30x00000000000C50850x00000000000C50730x00000000000C50760x00000000000C500D0x00000000000F07230x0000000000375E090x00000000000A4E950x00000000000C4FF40x00000000000C4FFD0x00000000000A4DD10x000000000086018B0x00000000000C506D0x0000000000868B4D0x0000000000868B500x000000000082CCA40x00000000003754830x0000000000868B410x000000000082CC9D0x00000000000CCE210x00000000000A557F0x000000000009AB0B0x00000000001C8C530x00000000000C45690x00000000000E9B6F0x00000000000E9B8D0x000000000086A3870x00000000003A16590x0000000000868B560x00000000000EAF3E0x000000000009AB140x00000000000C50100x00000000000C4FE50x00000000000C500A0x00000000000C50820x00000000000C4FBE0x00000000000A558E0x00000000000E9B5D0x000000000009AB1C0x00000000000CD3F90x0000000000868B530x00000000000CD9200x00000000000A3EAA0x00000000000E9B930x000000000061553E0x00000000000A55910x00000000000A37A60x00000000000E9B600x000000000009AB260x00000000003B29D80x00000000003755090x00000000003754F90x00000000000D91D60x000000000009AB2B0x00000000003B2A630x00000000003C0DA70x00000000003B2A120x000000000037551B0x00000000003B29FF0x00000000003B29ED0x00000000003754FC0x000000000009AB330x00000000000E9D250x00000000000E9CF10x00000000000E9D070x00000000003873870x000000000038738A0x00000000000CFC6B0x00000000000E9BB40x00000000003754D20x00000000003B2A990x00000000003C0D8F0x00000000000E9BC90x00000000000A4E980x000000000082CCF20x00000000000A4E9B0x00000000003B2A1B0x00000000003A16650x00000000003754F00x00000000000A75570x00000000000A8A9D0x00000000000A51040x00000000000A50250x00000000000A500D0x00000000000CD93E0x00000000003B2A960x00000000003B2A3F0x00000000000CFC6E0x00000000000A8AA30x00000000000EA2D10x00000000000A78620x00000000000A78770x00000000000A787D0x00000000003B2A420x00000000003B2A540x00000000000CFC740x000000000009AB560x00000000000D03920x00000000000A75600x00000000000E9D190x00000000000E9CF70x00000000000E9D280x00000000000E9CFD0x00000000000F07380x00000000000D03950x000000000037551E0x000000000037550F0x00000000000E9B810x00000000000A378E0x00000000000A37910x0000000000837C1E0x00000000000A50130x00000000000A4EC50x00000000000E9BC00x00000000003755120x000000000037550C0x00000000000A8AA90x00000000000A75750x00000000000A757B0x00000000000A559D0x000000000009AB6E0x00000000000A75990x00000000008765B40x000000000082CC7F0x00000000003B2A570x000000000082973F0x00000000000F09BE0x00000000000A75960x000000000009AB760x00000000003B2A9C0x00000000003754890x00000000000CCE240x00000000000EA39A0x00000000000A78830x00000000003B2A9F0x000000000009AB7D0x00000000000E9B630x00000000000CFC770x00000000000A75A80x00000000000A75B10x00000000000A55A00x00000000000E9B9F0x0000000000375E0F0x00000000000A75B4
--> 测试数据：#tbIF OBJECT_ID('TEMPDB.DBO.#tb') IS NOT NULL DROP TABLE #tbGOCREATE TABLE #tb([ufts] VARBINARY(8))INSERT #tbSELECT 0x000000000009AA24 UNION ALLSELECT 0x000000000009AA25 UNION ALLSELECT 0x000000000009AEE6 UNION ALLSELECT 0x000000000009AEE7 UNION ALLSELECT 0x000000000009AEE8GO--> 测试语句：SELECT cast([ufts] as int) FROM #tb/*(无列名)633380633381634598634599634600*/
[解决办法]
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 行受影响) */