当前位置: 代码迷 >> Sql Server >> Convert解决办法
  详细解决方案

Convert解决办法

热度:21   发布时间:2016-04-24 21:13:31.0
Convert
select convert(binary, 'b182379c4d3748919b21d4fd78dc11a4')

---0x6231383233373963346433373438393139623231643466643738646331316134

------解决方案--------------------
select convert(binary, 'b')
select convert(binary, '0182379c4d3748919b21d4fd78dc11a4')
select convert(binary, 'b182379c4d3748919b21d4fd78dc11a4')

/*

--------------------------
0x620000000000000000000000000000000000000000000000000000000000

(1 行受影响)


--------------------------
0x303138323337396334643337343839313962323164346664373864633131

(1 行受影响)


--------------------------
0x623138323337396334643337343839313962323164346664373864633131

(1 行受影响)
*/


???
  相关解决方案