SQL Server Binary转换

来源:互联网 发布:矩阵的转置怎么求 编辑:程序博客网 时间:2024/05/22 06:11
DECLARE @hexstring VARCHAR(MAX)='E0F0C0';SELECT CAST('' AS XML).value('xs:hexBinary(substring(sql:variable("@hexstring"), sql:column("t.pos")) )', 'VARBINARY(MAX)')FROM (SELECT CASE SUBSTRING(@hexstring, 1, 2) WHEN '0x' THEN 3 ELSE 0 END) AS t(pos)