[转载]mssql函数bin2str

  文章作者：xiaolu

create function f_bin2str(@b varbinary(8000))
returns varchar(8000)
as
begin
declare @r varchar(8000)
exec master..xp_varbintohexstr @b,@r out
return(@r)
end
go




select dbo.f_bin2str(pwd) as strbin from test where id=1

0xA386A494944E1BF9C660B2F0B04A0952
（1 行受到影响）