[转载]mssql函数bin2str
文章作者：xiaolucreate 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 行受到影响）
页:
[1]