_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › CONVERTFunction
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
*/

覓語 覦企襴(16讌)襯 覦企襴襦 覲蟆渚蠍
declare @str_bin varchar(20)
set @str_bin = '00E5A473'
select convert(binary(4), '0x'+@str_bin, 1)

/* 蟆郁骸
0x00E5A473
*/
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

螻 覓願 蟆 譴 襯 朱 蟆企. (W.)