读书人

Convert解决办法

发布时间: 2013-07-08 14:13:00 作者: rapoo

Convert
select convert(binary, 'b182379c4d3748919b21d4fd78dc11a4')

---0x6231383233373963346433373438393139623231643466643738646331316134
[解决办法]

select convert(binary, 'b')
select convert(binary, '0182379c4d3748919b21d4fd78dc11a4')
select convert(binary, 'b182379c4d3748919b21d4fd78dc11a4')

/*

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

(1 行受影响)


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

(1 行受影响)


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

(1 行受影响)
*/


???

读书人网 >SQL Server

热点推荐