Loading [MathJax]/jax/output/CommonHTML/config.js
首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
社区首页 >问答首页 >Server : BINARY_CHECKSUM给出相同值的不同结果

Server : BINARY_CHECKSUM给出相同值的不同结果
EN

Stack Overflow用户
提问于 2015-10-31 17:57:17
回答 1查看 1.2K关注 0票数 1

关于Server的BINARY_CHECKSUM函数,我有一个奇怪的问题。下面的代码(只需在您的管理演播室中复制和查询它)返回不同版本Server在不同机器上的不同校验和值(我不确定这是由于版本差异还是服务器差异而发生的)。

备注:

  • 该值实际上是一个二进制文件,存储在Server中。但这不是我想的,价值本身就在那里
  • 查询返回服务器1上的1475829670值(使用server 2005)
  • 并返回服务器2上的1024353818值(使用server 2008)。
  • 并返回服务器3上的1024353818值(使用server 2012)。

查询是:

代码语言:javascript
代码运行次数:0
运行
AI代码解释
复制
select 
/*
* 提示:该行代码过长,系统自动注释不进行高亮。一键复制会移除系统注释 
* BINARY_CHECKSUM(0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300F53DEF550000000000000000E00002210B0108000028000000060000000000005E46000000200000006000000000400000200000000200000400000000000000040000000000000000A0000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000000C4600004F00000000600000C002000000000000000000000000000000000000008000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000064260000002000000028000000020000000000000000000000000000200000602E72737263000000C00200000060000000040000002A0000000000000000000000000000400000402E72656C6F6300000C0000000080000000020000002E0000000000000000000000000000400000420000000000000000000000000000000040460000000000004800000002000500082D00000419000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E02280300000A2A4E027C010000047B0400000A6F0500000A26172A2602037D01000004172A000003300500BD00000000000000027C010000047C0600000A7B0700000A720100007016720900007072090000706F0800000A26027C010000047C0600000A7B0900000A7201000070166F0A00000A26027C010000047C0600000A7B0B00000A7201000070176F0C00000A26027C010000047C0600000A7B0700000A720B00007016720900007072090000706F0800000A26027C010000047C0600000A7B0900000A720B000070166F0A00000A26027C010000047C0600000A7B0B00000A720B000070176F0C00000A262A000000133005000A010000010000111200FE15040000011200177D0D00000A0F017B0E00000A1F0A331412000228070000068C0F0000017D0F00000A062A0F017B0E00000A20C900000033261200020F017B1000000A169A74100000010F017B1000000A179A28080000067D0F00000A062A0F017B0E00000A1F7A3316020F017B1000000A169AA5110000012809000006062A0F017B0E00000A1F6533221200020F017B1000000A169AA511000001280A0000068C0F0000017D0F00000A062A0F017B0E00000A1F7C330802280B000006062A0F017B0E00000A1F793316020F017B1000000A169AA511000001280C000006062A0F017B0E00000A1F0F3308022804000006062A1200167D0D00000A1200147D0F00000A062ADA031F0A3302172A0320C90000003302172A031F7A3302172A031F653302172A031F7C3302172A031F793302172A031F0F3302172A162A000000133005006104000002000011027C010000047C1100000A7B1200000A72170000706F1300000A027C010000047C1100000A7B1400000A722B0000706F1500000A72550000700A067284010070281600000A0A067202020070281600000A0A06727C020070281600000A0A0672EA020070281600000A0A067279030070281600000A0A0672F7030070281600000A0A027C010000047C1100000A7B1700000A066F1800000A027C010000047C1100000A7B1900000A720B0000706F1A00000A027C010000047C0600000A7B0700000A7210050070167209000070146F0800000A26027C010000047C0600000A7B0700000A722A050070167209000070146F0800000A26027C010000047C0600000A7B0700000A723A0500701F0C723A050070146F0800000A26027C010000047C0600000A7B1B00000A723A050070166F1C00000A26027C010000047C0600000A7B0700000A7244050070167244050070146F0800000A26027C010000047C0600000A7B0700000A7260050070167260050070146F0800000A26027C010000047C0600000A7B0700000A727E05007016727E050070146F0800000A26027C010000047C0600000A7B0700000A72A20500701672A2050070146F0800000A26027C010000047C0600000A7B0700000A72C00500701672C0050070146F0800000A26027C010000047C0600000A7B0700000A72E20500701F0A72E2050070146F0800000A26027C010000047C0600000A7C1D00000A7B1E00000A72E20500707202060070721A0600706F1F00000A26027C010000047C0600000A7C1D00000A7B1E00000A72E20500707234060070724E0600706F1F00000A26027C010000047C0600000A7B0700000A726A0600701F0A726A060070728C0600706F0800000A26027C010000047C0600000A7C1D00000A7B1E00000A726A060070728C06007072940600706F1F00000A26027C010000047C0600000A7C1D00000A7B1E00000A726A06007072B406007072BE0600706F1F00000A26027C010000047C0600000A7B0700000A72D80600701772D806007072090000706F0800000A26027C010000047C0600000A7B0700000A72F60600701972F6060070168C0F0000016F0800000A26027C010000047C0600000A7B0700000A721C07007019721C070070178C0F0000016F0800000A26027C010000047C0600000A7B0700000A72480700701B7248070070146F0800000A26027C010000047C0600000A7B0700000A72720700701F0F7272070070168C0F0000016F0800000A26027C010000047C0600000A7B0700000A72A00700701F0F72A0070070168C0F0000016F0800000A26027C010000047C0600000A7B0900000A7248070070166F0A00000A26027C010000047C0600000A7C2000000A7B2100000A72A007007072D60700706F2200000A26027C010000047C0600000A7C2000000A7B2100000A727207007072140800706F2200000A26027C010000047C1100000A7B2300000A166F2400000A027C010000047C1100000A7B2500000A166F2600000A027C010000047C1100000A7B2700000A166F2800000A172A000000033003000D020000000000000372F6060070282900000A39AC010000027C010000047C0600000A7B2A00000A72F60600706F2B00000A3AC9000000027C010000047C0600000A7B0900000A726A060070166F0A00000A26027C010000047C0600000A7B0900000A72D8060070166F0A00000A26027C010000047C0600000A7B0900000A72E2050070166F0A00000A26027C010000047C0600000A7B0900000A7244050070166F0A00000A26027C010000047C0600000A7B0900000A72A2050070166F0A00000A26027C010000047C0600000A7B0900000A7260050070166F0A00000A26027C010000047C0600000A7B0900000A727E050070166F0A00000A2638C4000000027C010000047C0600000A7B0900000A726A060070176F0A00000A26027C010000047C0600000A7B0900000A72D8060070176F0A00000A26027C010000047C0600000A7B0900000A72E2050070176F0A00000A26027C010000047C0600000A7B0900000A7244050070176F0A00000A26027C010000047C0600000A7B0900000A72A2050070176F0A00000A26027C010000047C0600000A7B0900000A7260050070176F0A00000A26027C010000047C0600000A7B0900000A727E050070176F0A00000A260372A0070070282900000A2C4204282C00000A2C1E027C010000047C0600000A7B0900000A7248070070176F0A00000A262B1C027C010000047C0600000A7B0900000A7248070070166F0A00000A26142A00000013300400FE01000003000011027C010000047C2D00000A7B2E00000A72580800706F2F00000A7280080070282900000A2C79027C010000047C3000000A7C3100000A7B3200000A6F3300000A027C010000047C3000000A7C3100000A7B3400000A72F6060070027C010000047C0600000A7B2A00000A72F60600706F2B00000A8C0F0000016F3500000A027C010000047C3000000A7C3100000A7B3600000A7288080070036F3700000A26027C010000047C2D00000A7B2E00000A72580800706F2F00000A7298080070282900000A3910010000027C010000047C2D00000A7B2E00000A72A20800706F2F00000A0A027C010000047C2D00000A7B2E00000A72E20800706F2F00000A26722209007006722A090070283800000A0B72090000700C027C010000047C0600000A7B2A00000A72F60600706F2B00000A0D027C010000047C0600000A7B3900000A723A0500706F3A00000A1304092C331A8D290000011305110516723A090070A211051707A2110518724A090070A2110519038C11000001A21105283B00000A0C2B321A8D290000011306110616723A090070A211061707A211061872CF090070A211061911048C11000001A21106283B00000A0C087209000070283C00000A2C17027C010000047C3000000A7B3D00000A086F3E00000A26027C010000047C3F00000A7C4000000A7B4100000A72330A007072490A00706F4200000A262A0A172A000000133003002900000004000011027C010000047C4300000A7B4400000A723A050070166F4500000A284600000A0A0206280D0000062A000000133003002900000004000011027C010000047C4300000A7B4400000A723A050070166F4500000A284600000A0A0206280D0000062A000000033006005901000000000000027C010000047C3000000A7B4700000A72590A0070725D0A00700F01284800000A281600000A6F4900000A26027C010000047C0600000A7B4A00000A723A050070027C010000047C3000000A7B4B00000A72590A007072FA0A0070166F4C00000A8C110000016F4D00000A26027C010000047C0600000A7B4A00000A7201000070027C010000047C3000000A7B4E00000A72590A00707201000070166F4F00000A6F4D00000A26027C010000047C0600000A7B4A00000A720B000070027C010000047C3000000A7B4E00000A72590A0070720B000070166F4F00000A6F4D00000A26027C010000047C0600000A7B4A00000A7210050070027C010000047C3000000A7B4E00000A72590A00707210050070166F4F00000A6F4D00000A26027C010000047C0600000A7B4A00000A722A050070027C010000047C3000000A7B4E00000A72590A0070722A050070166F4F00000A6F4D00000A262A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C000000C4040000237E0000300500001407000023537472696E677300000000440C0000000B0000235553004417000010000000234755494400000054170000B001000023426C6F620000000000000002000001571702000900000000FA013300160000010000003300000002000000010000000D00000009000000010000004F0000000200000004000000010000000200000000000A0001000000000006003C0035000A0065004F000A0087004F000A00B4004F000A00C9004F000A000101E5000600D301B3010600F301B3010A00410221020A00820264020A00910221020A00A002E5000A00AB0221020A00C80221020600F702350006000C0335000600130335000A00190364020A002D0321020A00580321020A008A0321020A00B30321020A00DA0321020A00F70364020A00100421020A002C0464020A00400421020A005F0421020A008E0421020A00BF0421020A00050521020600260535000A00410564020A00600521020A00870564020A00920564020A00A20521020A00B60521020A00D20521020A00E60521020600050635000A001A0621020A002F0664020A00420664020A00500621020A00770664020A00980621020A00BC0621020A00D60621020A00EF0621020A00000721020000000001000000000001000100010010001E000000050001000100010097001200502000000000861876000A000100582000000000E6017C000E0001006C2000000000E6019B00160001007820000000008600A5000A000200442100000000E601DB001C0002005A2200000000E6010A0123000300942200000000860016010E000400042700000000860027012900040020290000000086003C012F0006002A2B000000008600540134000700302B00000000860074010A000800682B0000000086008B012F000800A02B000000008100A3012F000900000001005F0200000100E70200000100F10200000100F40400000200FF0200000100380500000100380500000100380500000100B90602000900390076002F00410076000A00090076000A00190050023900490058020E0019008A023D0051009C0241005900580245005100BD024E006900580252005100DB0258007100580252002100EB025C002900F1025F002100FF026300290005036600190024036F00910048037300990058027700910073037C00A100580277008100830380009100A4038600A900580277009100CC038A00B100580277005100EC038E00B90058025200510004049200C10024049600C90058029A0051003704A100D1005404A500D9005802A90091007C04AF00E1005802B3009100AC04B800E9005802B3009100DF04BC00F1005802B3008100F904C40051001905CA00F9005802CE0001012E05D30019005105D80009017B05DD0011015802E20019008D05E70019019D05EC002101B105F100290158020A002101C905F60031015802FB002101E1050101390158020601810083030C015100F9051301410158021801810083031D0181000C06C40019012706230151015802CE00190039062801590197002D0161016A0632016901580229001900880643017101AD064801790158024D010101B10653011901C7065C018900CD06610181015802A9005100E60665011901F9056A01910158026F0189015802760119017B057C019901580281012E000B0088012E00130091016A00C000370158010480000000000000000000000000000000001102000002000000000000000000000001002C000000000001000000000000000000000000004F00000000000000003C4D6F64756C653E00434F44452E45465F434854414E494D2E646C6C004C454441465F434F4445455854006D73636F726C69620053797374656D004D61727368616C42795265664F626A656374004C45444170704672616D65776F726B2E547970657300494C45444170704672616D65776F726B002E63746F720041534D5245465245534800744C4544414646554E4354494F4E53004C414600494E49545459504553004C4F41444F424A4543544C49535400494C41465F43414C4C4556454E54524553554C5400494C41465F43414C4C4556454E544152470043414C4C4556454E54004C45444170704672616D65776F726B2E54797065732E456E756D73004556454E54444543004556454E5445584953545300464F524D4556454E545F4F4E494E495400454449544F524556454E545F4F4E4348414E47450041464556454E545F4146544552534156455245434F52440041464556454E545F4F4E434845434B53415645524551554952454D454E54530041464556454E545F41465445524E45575245434F52440041464556454E545F41465445524C4F41445245434F5244006361726962696C67695F79756B6C650053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500434F44452E45465F434854414E494D004C45444170704672616D65776F726B2E54797065732E44656C656761746573004C41465F5245465245534841534D005245465245534800496E766F6B650046554E43004C45444170704672616D65776F726B2E54797065732E5374727563747300454449544F525300454449544F5200454449544F525F4144440041444400454449544F525459504500454449544F525F534554454E41424C454400534554454E41424C454400454449544F525F534554524541444F4E4C5900534554524541444F4E4C59004152470056414C4944004556454E5400426F6F6C65616E0056414C55450056414C55455300537472696E6700496E7433320050524F504552544945530050524F50455254590050524F504552544945535F5345545F4445434C45524154494F4E005345545F4445434C45524154494F4E0050524F504552544945535F5345545F44425441424C454E414D45005345545F44425441424C454E414D4500436F6E6361740050524F504552544945535F5345545F4442564945574E414D45005345545F4442564945574E414D450050524F504552544945535F5345545F4E414D454649454C44005345545F4E414D454649454C4400454449544F525F53455456495349424C450053455456495349424C45004C4F4F4B5550434F4D424F53004C4F4F4B5550434F4D424F004C4F4F4B5550434F4D424F5F4144444954454D004144444954454D00434845434B424F58455300434845434B424F5800434845434B424F585F53455443415054494F4E0053455443415054494F4E0050524F504552544945535F5345545F53484F574E4557425554544F4E005345545F53484F574E4557425554544F4E0050524F504552544945535F5345545F53484F574C4F4144425554544F4E005345545F53484F574C4F4144425554544F4E0050524F504552544945535F5345545F53484F5744454C455445425554544F4E005345545F53484F5744454C455445425554544F4E004E414D45006F705F457175616C69747900454449544F525F47455456414C5545424F4F4C0047455456414C5545424F4F4C00436F6E7665727400546F426F6F6C65616E005245434F524449440053595354454D5641524941424C45530053595354454D5641524941424C450053595354454D5641524941424C455F47455456414C55455354520047455456414C554553545200444154415300444154410044415441535F53415645005341564500444154415F534156455F494E495400494E495400444154415F534156455F41444456414C55450041444456414C554500444154415F534156455F45584543004558454300454449544F525F47455456414C5545494E540047455456414C5545494E54004F626A656374006F705F496E657175616C69747900444154415F4558454355544500455845435554450045585445524E414C530045585445524E414C0045585445524E414C5F4C4146530045585445524E414C5F4C41465F53454E445F434F4D4D414E440053454E445F434F4D4D414E440043414C4C4552504152414D45544552530043414C4C4552504152414D455445520043414C4C4552504152414D45544552535F4745540047455400546F496E74333200696400444154415F515545525900515545525900546F537472696E6700454449544F525F53455456414C55450053455456414C554500444154415F47455456414C5545494E5400444154415F47455456414C55455354520000000000074B004F0044000001000B55004E00560041004E000013430061007200690020004B0061007200740000296C006500640065006600610074007500720061002E0063006100720069006400650074006100790000812D2800730065006C0065006300740020002A002000660072006F006D0020002800730065006C006500630074002000640074002E00490044002C00640074002E0043004800490044002C00640074002E0045004600410054005500520041005F0055004E00560041004E002C00640074002E0045004600410054005500520041005F00540043004B004E00410044002C00640074002E0045004600410054005500520041005F00540043004B004E0053004F005900410044002C00640074002E0045004600410054005500520041005F0053005500420045004E004F002C00640074002E0045004600410054005500520041005F00530045004E004100520059004F002C00640074002E0045004600410054005500520041005F005300410054004900430049004E004F002000007D2C00640074002E0045004600410054005500520041005F00560045005200470049005400490050002C00640074002E0045004600410054005500520041005F004500540049004B00450054002C00640074002E0045004600410054005500520041005F004200410053004C0041004D0041005400410052004900480000792C00490053004E0055004C004C002800640074002E0045004600410054005500520041005F00530055004E005500430055004B004F004E00540052004F004C002C0031002900200061007300200045004600410054005500520041005F00530055004E005500430055004B004F004E00540052004F004C00006D2C00490053004E0055004C004C002800640074002E0045004600410054005500520041005F004B0055004C004C0041004E00490059004F0052002C0030002900200061007300200045004600410054005500520041005F004B0055004C004C0041004E00490059004F00520000808D2C00490053004E0055004C004C002800640074002E0045004600410054005500520041005F004200410053004C0041004D004100540041005200490048004B0055004C004C0041004E002C0030002900200061007300200045004600410054005500520041005F004200410053004C0041004D004100540041005200490048004B0055004C004C0041004E00007D2C00490053004E0055004C004C002800640074002E0045004600410054005500520041005F004E0045005400540055005400410052004B0055004C004C0041004E002C0030002900200061007300200045004600410054005500520041005F004E0045005400540055005400410052004B0055004C004C0041004E000081172C00630068002E004B004F0044002C00630068002E0055004E00560041004E002C00630068002E005600450052004700490044004100490052004500530049002C00630068002E00560045005200470049004E004F002000660072006F006D0020006C006500640065006600610074007500720061002E006300610072006900640065007400610079002000640074002C006C006500640065006600610074007500720061002E0077006300610072006900740061006E0069006D002000630068002000770068006500720065002000630068002E00490044003D00640074002E004300480049004400290020006100730020006D0079007400610062006C00650029006100730020007400610062006C00650031000019560045005200470049004400410049005200450053004900000F560045005200470049004E004F0000094300480049004400001B45004600410054005500520041005F0055004E00560041004E00001D45004600410054005500520041005F00540043004B004E0041004400002345004600410054005500520041005F00540043004B004E0053004F00590041004400001D45004600410054005500520041005F0053005500420045004E004F00002145004600410054005500520041005F005300410054004900430049004E004F00001F45004600410054005500520041005F00530045004E004100520059004F000017540045004D0045004C004600410054005500520041000019540065006D0065006C0020004600610074007500720061000019540049004300410052004900460041005400550052004100001B5400690063006100720069002000460061007400750072006100002145004600410054005500520041005F0056004500520047004900540049005000000756004B004E00001F5600650072006700690020004B0069006D006C0069006B0020004E006F000009540043004B004E000019540043002E004B0069006D006C0069006B0020004E006F00001D45004600410054005500520041005F004500540049004B0045005400002545004600410054005500520041005F004B0055004C004C0041004E00490059004F005200002B45004600410054005500520041005F00530055004E005500430055004B004F004E00540052004F004C00002945004600410054005500520041005F004200410053004C0041004D00410054004100520049004800002D45004600410054005500520041005F004E0045005400540055005400410052004B0055004C004C0041004E00003545004600410054005500520041005F004200410053004C0041004D004100540041005200490048004B0055004C004C0041004E00003D420061005F016C0061006E0067003101E70020005400610072006900680069006E00690020005200650066006500720061006E007300200041006C0001434B0061006C0065006D00200054007500740061007200200041006C0061006E0031016E00640061006E002000300173006B006F006E0074006F0020004400FC005F01012745004600410054005500520041005F0055005900470055004C0041004D0041004B004F00440000074C0045004400000F63006800740061006E0069006D0000094C004F0047004F00003F45004600410054005500520041005F0055005900470055004C0041004D0041004B004F0044005F004C004F0047004F004600490052004D0041004E004F00003F45004600410054005500520041005F0055005900470055004C0041004D0041004B004F0044005F004C004F0047004F0044004F004E0045004D004E004F0000074C0047005F00000F5F0043004C004300410052004400000F75007000640061007400650020000080832000730065007400200044004500460049004E004900540049004F004E0032003D00270045002D0046006100740075007200610027002C0053005000450043004F004400450035003D00270045002D00460061007400750072006100270020007700680065007200650020004C004F0047004900430041004C005200450046003D0001632000730065007400200044004500460049004E004900540049004F004E0032003D00270027002C0053005000450043004F004400450035003D002700270020007700680065007200650020004C004F0047004900430041004C005200450046003D000115450046005F00430048004C004900530054004500000F52004500460052004500530048000003710000809B530045004C004500430054002000490044002C004B004F0044002C0055004E00560041004E002C005600450052004700490044004100490052004500530049002C00560045005200470049004E004F002000660072006F006D0020006C006500640065006600610074007500720061002E0077006300610072006900740061006E0069006D002000770068006500720065002000490044003D0000054900440000B8F9035DD979D74FBA5225767E1589DF0008B77A5C561934E08903200001032000020306110D05200102110D062001111111150520010211190520021C0E1C0420010108042001020803061225030611290306122D082004020E11310E1C03061235052002020E02030612390206020306111902061C03061D1C0407011111030611490306124D042001010E030612510500020E0E0E03061255030612590306125D0306116103061265062003020E0E0E030611690306126D052002020E0E03061271042001010203061275030612790307010E050002020E0E0306127D042001020E040001021C040611808504061280890420010E0E040611808D040611809104061280950406128099052002010E1C040612809D052002080E080600030E0E0E0E04061280A1042001080E0500010E1D1C04061280A904061180AD04061180B104061280B50B07070E0E0E02081D1C1D1C04061180B904061280BD0520020E0E08040001080E0307010804061280C10320000E04061280C504061280C9062003080E0E08052002020E1C04061280CD0620030E0E0E080801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773013446000000000000000000004E46000000200000000000000000000000000000000000000000000040460000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058600000640200000000000000000000640234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004C4010000010053007400720069006E006700460069006C00650049006E0066006F000000A001000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000048001400010049006E007400650072006E0061006C004E0061006D006500000043004F00440045002E00450046005F0043004800540041004E0049004D002E0064006C006C0000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000005000140001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000043004F00440045002E00450046005F0043004800540041004E0049004D002E0064006C006C000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000C000000603600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000)
*/

我被困在这里好几个小时了。谢谢你的帮助。

EN

回答 1

Stack Overflow用户

发布于 2015-11-01 07:05:40

对于字节更改验证,您应该使用HASHBYTES,它有一个已发布的用于生成其散列的算法列表。

BINARY_CHECKSUM,就像CHECKSUM一样,很容易受到缺少的更改的影响,因此不能用于此目的。来自校验和文章的备注部分。

但是,校验和不会改变的可能性很小。因此,我们不建议使用校验和来检测值是否已经更改,除非您的应用程序可以容忍偶尔丢失一个更改。考虑使用HashBytes。当指定MD5哈希算法时,HashBytes对两个不同输入返回相同结果的概率大大低于校验和的概率。

正如Vladimir注释所指出的,SQL 2005之后的行为可能会发生变化,但无论如何,任何CHECKSUM方法的目的都是为了“哈希索引”,所以唯一性永远不是guaranteed...which --任何散列算法都无法保证其唯一性,每个方法都试图提高不使用相同散列查找两个不同值的概率。

票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/33458492

复制
相关文章
Anbox:在 Linux 上运行 Android 应用程序的简单方式
Anbox 是 “Android in a box” 的缩写。Anbox 是一个基于容器的方法,可以在普通的 GNU/Linux 系统上启动完整的 Android 系统。
用户8639654
2021/09/23
5.2K0
7个有用的Pandas显示选项
andas是一个在数据科学中常用的功能强大的Python库。它可以从各种来源加载和操作数据集。当使用Pandas时,默认选项就已经适合大多数人了。但是在某些情况下,我们可能希望更改所显示内容的格式。所以就需要使用Pandas的一些定制功能来帮助我们自定义内容的显示方式。
deephub
2023/02/01
1.3K0
使枚举类型的选项在VS的属性窗里显示为中文
我们自己做的组件,一般希望它的属性在设计时能够在属性窗里显示为中文,可以在属性上添加System.ComponentModel.DisplayNameAttribute标注达到这个目的。但是,枚举的选项如何以中文的形式显示在属性窗里呢?
明年我18
2019/09/18
1.2K0
使枚举类型的选项在VS的属性窗里显示为中文
Spring Boot 如何以 Web 应用的方式启动
https://www.cwiki.us/display/SpringBootZH/questions/57938770
HoneyMoose
2020/04/04
4510
Spring Boot 如何以 Web 应用的方式启动
带有-i选项的sed命令在Linux上执行成功,但在MacOS上失败
就地编辑文件(如果提供了后缀,则进行备份),可见参数后缀 SUFFIX 是可选的,即带或者不带这个参数都可以执行。
程序熵
2023/09/25
3770
带有-i选项的sed命令在Linux上执行成功,但在MacOS上失败
EXCEL单元格的引用方式
EXCEL单元格的引用包括相对引用、绝对引用和混合引用三种。 相对引用   公式中的相对单元格引用(例如 A1)是基于包含公式和单元格引用的单元格的相对位置。如果公式所在单元格的位置改变,引用也随之改变。如果多行或多列地复制公式,引用会自动调整。默认情况下,新公式使用相对引用。例如,如果将单元格 B2 中的相对引用复制到单元格 B3,将自动从 =A1 调整到 =A2。 绝对引用   单元格中的绝对单元格引用(例如 $A$1)总是在指定位置引用单元格。如果公式所在单元格的位置改变,绝对引用保持
用户1075292
2018/01/23
1.4K0
将jpeg图片显示在framebuffer上
点击(此处)折叠或打开 /************************************************** * example5.c * Author: T-bagwell * * Compile:gcc -Wall example5.c -o example5 *************************************************/ #include <stdio.h> #inclu
用户3765803
2019/03/05
1.2K0
跳跃表---用简单的方式实现有序集合
遍历整个链表,时间复杂度为O(n),例如我们向查找7,即node4,需要4次查找
用户3946442
2022/04/11
4230
跳跃表---用简单的方式实现有序集合
[ASP.NET Core 3框架揭秘] Options[2]: 配置选项的正确使用方式[下篇]
前面演示的几个实例具有一个共同的特征,即都采用配置系统来提供绑定Options对象的原始数据,实际上,Options框架具有一个完全独立的模型,可以称为Options模型。这个独立的Options模型本身并不依赖于配置系统,让配置系统来提供配置数据仅仅是通过Options模型的一个扩展点实现的。在很多情况下,可能并不需要将应用的配置选项定义在配置文件中,在应用启动时直接初始化可能是一种更方便快捷的方式。
蒋金楠
2020/02/12
9320
显示器 设置选项 解析
明亮度 Gama:显示器的输出图像对输入信号的失真程度。 DCR:Dynamic Contrast Ratio,动态对比率。自动判断画面整体亮度,对画面各部分进行亮度调整,使细节更清晰,层次更分明。 颜色设置 色温 暖色 正常 冷色 sRGB:RGB(色彩空间)的一种标准。 DCB模式 OSD设置 其他 DDC/CI:Display Data Channel Command Interface,基于DDC/CI协议,用户可以通过鼠标和人性化的软件界面来完成显示器的各项设置和色彩调节,
JNingWei
2018/09/28
1.6K0
直接iframe方式在网页上显示天气插件
天气预报调用网址(可定制):http://www.tianqi.com/plugin/
科控物联
2023/09/22
1.4K0
直接iframe方式在网页上显示天气插件
PageRank算法在spark上的简单实现
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/wzy0623/article/details/51383232
用户1148526
2019/05/25
1.5K0
Excel表格的35招必学秘技[配图]
一、让数据按需排序   如果你要将员工按其所在的部门进行排序,这些部门名称既的有关信息不是按拼音顺序,也不是按笔画顺序,怎么办?可采用自定义序列来排序。   1.执行“格式→选项”命令,打开“选项”
ytkah
2018/03/06
7.6K0
Excel表格的35招必学秘技[配图]
显示方式
08.05自我总结 一.显示方式 1.display 常用的三种方式 #第一种block 1.支持设置宽高 2.自带换行 一般情况所有有宽高、参与位置布局的都是block #第二种inline 1.不支持设置宽高,宽高只能有文本撑开 2.不带换行,一行显示不下会自动换行(保留数据的整体性) 一般情况存放文本的 #第三种inline-block 1.支持设置宽高 2.不带换行,一行显示不下会自动换行(以标签整体换行,标签左右有间距) 一般情况不去主动设置该显示方式,系统的两个img、input都设置为了单
小小咸鱼YwY
2019/09/11
6530
支持公式的3款Excel替代品
随着大数据、企业数字化转型等不可逆趋势的推动下,似乎一切变得皆可量化和数据化,企业在解决问题时,也更为倾向于以数据表格来作为判断决策是否正确的重要标志,这时具有数据思维和数据分析处理技能,成了当前及未来人才发展不可忽视的能力之一。今天给大家带来3款Excel替代品的对比,由大家来评判一下。
用户10264843
2023/02/09
3.5K0
[ASP.NET Core 3框架揭秘] Options[1]: 配置选项的正确使用方式[上篇]
依赖注入不仅是支撑整个ASP.NET Core框架的基石,也是开发ASP.NET Core应用采用的基本编程模式,所以依赖注入十分重要。依赖注入使我们可以将依赖的功能定义成服务,最终以一种松耦合的形式注入消费该功能的组件或者服务中。除了采用依赖注入的形式消费承载某种功能的服务,还可以采用相同的方式消费承载配置数据的Options对象。
蒋金楠
2020/02/12
1.1K0
mapboxGL卷帘实现
卷帘对比是webgis中常见的一种对比方式,本文讲述一下如何在mapboxGL中实现卷帘对比。
牛老师讲GIS
2021/09/10
1.8K0
在ListView上使用自定义的Adapter
需要实现的东西是: 一个DataListViewAdapter,当进行如下调用时,就能在列表上显示出数据:
LeoXu
2018/08/15
9700
点击加载更多

相似问题

如何以编程方式在自定义单元格上添加自定义视图?

11

简单产品上的自定义选项无法在订单上显示

31

如何以简单的方式显示加载指示器?

211

简单的Kivy手势(卷帘)

10

如何以简单的方式在Mac上安装gst (gstreamer绑定)?

27
添加站长 进交流群

领取专属 10元无门槛券

AI混元助手 在线答疑

扫码加入开发者社群
关注 腾讯云开发者公众号

洞察 腾讯核心技术

剖析业界实践案例

扫码关注腾讯云开发者公众号
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档
查看详情【社区公告】 技术创作特训营有奖征文