2010/07/27

binary 데이터를 string으로 바꾸기

SELECT
Base_latest_rank
, replace(sys.fn_varbintohexstr(Base_latest_rank),'0x','')
FROM [janranking].[dbo].[JMTopView_Common]
where Base_latest_rank is not null

댓글 없음: