SQL里列类型为varbinary的，能当where 条件进行查询吗？

[好奇都是要学的]

请问SQL里 varbinary类型的列 能用来当where 条件吗？
select * from BigSettlement where
SettlementData='0x10780B0068026B0000005BE58D83E588865D205B33E4BABAE58D83E588865D20E4BF9DE79599362C372C20E5969CE58886E58AA02C20E5A5963130302CE689A334302C36302C20E5A596E58AB13130302C20E4B88AE6B8B8E5BE97E5A5962C20E688BFE4B8BBE5BC80E688BF2020E7ACAC31E5B1800000000003000000F84300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F74300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB100000000000000000B0000000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F843000000000000'
数值没错。 但是结果一行没有

[OwenZeng_DBA]

引用 楼主 wang2129929 的回复:

请问SQL里 varbinary类型的列 能用来当where 条件吗？ select * from BigSettlement where SettlementData='0x10780B0068026B0000005BE58D83E588865D205B33E4BABAE58D83E588865D20E4BF9DE79599362C372C20E5969CE58886E58AA02C20E5A5963130302CE689A334302C36302C20E5A596E58AB13130302C20E4B88AE6B8B8E5BE97E5A5962C20E688BFE4B8BBE5BC80E688BF2020E7ACAC31E5B1800000000003000000F84300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F74300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB100000000000000000B0000000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F843000000000000' 数值没错。 但是结果一行没有

可以，去掉引号

[好奇都是要学的]

引用 2 楼 z10843087 的回复:

[quote=引用 楼主 wang2129929 的回复:] 请问SQL里 varbinary类型的列 能用来当where 条件吗？ select * from BigSettlement where SettlementData='0x10780B0068026B0000005BE58D83E588865D205B33E4BABAE58D83E588865D20E4BF9DE79599362C372C20E5969CE58886E58AA02C20E5A5963130302CE689A334302C36302C20E5A596E58AB13130302C20E4B88AE6B8B8E5BE97E5A5962C20E688BFE4B8BBE5BC80E688BF2020E7ACAC31E5B1800000000003000000F84300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F74300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB100000000000000000B0000000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F843000000000000' 数值没错。 但是结果一行没有

可以，去掉引号[/quote] 谢谢。 那我想读取到 c#里那 string strsql = @"select * from QPAgentRechargeDB.dbo.BigSettlement"; DataSet ds = aideTreasureFacade.GetDataSetBySql(strsql); string bs = ds.Tables[0].Rows[0]["SettlementData"]; 怎么把 0x107....... 后面值赋给BS 变量那

[半世笙箫]

使用convert或cast转换成varchar或nvarchar类型，再进行运算

[好奇都是要学的]

引用 4 楼 weixin_38357227 的回复:

使用convert或cast转换成varchar或nvarchar类型，再进行运算

看这个https://bbs.csdn.net/topics/392393081?page=1#post-403274723

[好奇都是要学的]

引用 2 楼 z10843087 的回复:

[quote=引用 楼主 wang2129929 的回复:] 请问SQL里 varbinary类型的列 能用来当where 条件吗？ select * from BigSettlement where SettlementData='0x10780B0068026B0000005BE58D83E588865D205B33E4BABAE58D83E588865D20E4BF9DE79599362C372C20E5969CE58886E58AA02C20E5A5963130302CE689A334302C36302C20E5A596E58AB13130302C20E4B88AE6B8B8E5BE97E5A5962C20E688BFE4B8BBE5BC80E688BF2020E7ACAC31E5B1800000000003000000F84300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F74300000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB100000000000000000B0000000000000000000000040000000C000000E782B8E5BCB9E58886E695B0000000000000000009000000E680BBE7A7AFE5888600000000000000000C000000E59B9BE8888DE4BA94E585A500000000000000000C000000E5B0BEE5B180E5A596E58AB10000000000000000F843000000000000' 数值没错。 但是结果一行没有

可以，去掉引号[/quote] https://bbs.csdn.net/topics/392393081?page=1#post-403274723 看这个

[好奇都是要学的]

varbinary（max）

[薛定谔的DBA]

16进制转字符： SELECT master.dbo.fn_varbintohexstr(0x9473FBCF)