34,588
社区成员
发帖
与我相关
我的任务
分享
declare @Str nvarchar(1000)
set @Str='0x112AAABAAA'
select cast(CAST(@str as varbinary(max)) as nvarchar(max))
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0x112AAABAAA
(1 行受影响)*/
declare @Str nvarchar(1000)
set @Str='0x112AAABAAA'
select CAST(@str as varbinary(max))
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0x300078003100310032004100410041004200410041004100
(1 行受影响)*/