SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** 对象: 用户定义的函数 dbo.f_16 脚本日期: 2005-8-23 14:28:15 ******/
ALTER function f_16 (@vin varchar(100))
returns varchar(200)
as
begin
declare
@vtemp varchar(100),
@vout varchar(200),
@c varchar(100),
@vc char(10)
set @vtemp=@vin --9899
if @vtemp<16
begin
if @vtemp<=9
set @vtemp=@vtemp
else
begin
set @vtemp=left(@vtemp,2)
-- print @vtemp
set @vtemp=char(cast(@vtemp as int)+55)
-- print @vtemp
end
return @vtemp
end
set @vout=''
while @vtemp>=16
begin
set @c= @vtemp %16
if @c >9
begin
set @c=char(cast(@c as int)+55)
end
set @vout=@vout+@c
set @vtemp=@vtemp/16
end --while
set @vtemp= @vtemp+@vout
return @vtemp
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
select dbo.f_16('14')
返回 E