Contents

1 2000, 2005 버전

2 2008 버전

3 적용 범위

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

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

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
*/

• Microsoft SQL Server 2000
  
• Microsoft SQL Server 2005
  
• Microsoft SQL Server 2008