_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › Binary(HEX)豌企ゼ覓語企願鍵

Contents

1 2000, 2005 覯
2 2008 覯
3


1 2000, 2005 覯 #

create table #bin(b binary(1))
insert #bin values(0xff)
insert #bin values(0x0f)

select
	master.dbo.fn_varbintohexstr(b) binarytostr
from #bin

2 2008 覯 #

declare @chr varchar(4) = 'yasi';
declare @bin varbinary(4) = convert(varbinary(20), @chr);
select
	@bin bin
,	CONVERT(varchar(4), @bin, 0) style0
,	CONVERT(varchar(4), @bin, 1) style1
,	CONVERT(varchar(4), @bin, 2) sytel2
/*
bin        style0 style1 sytel2
---------- ------ ------ ------
0x79617369 yasi   0x79   7961

谿瑚: sys.fn_varbintohexstr
*/

3 #

  • Microsoft SQL Server 2000
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

磯Μ螳 覲牛讌 覿 磯Μ 螳螳 讌讌襦 苦 ロ伎 朱 豪麹蟆 り螳螻 碁. 蠏 豈 襷れ 覈企. (蟾蠍)