ALTER FUNCTION [dbo].[Convert36To10]
(
@str varchar(2)
)
RETURNS int
AS
BEGIN
DECLARE @X36 varchar(36);
DECLARE @rstr varchar(2);
DECLARE @rchar varchar(1);
DECLARE @idx int;
DECLARE @val int;
DECLARE @jval int;
set @X36 = '0123456789ABCDEFGHIJHKLMNOPQRSTUVWXYZ';
set @val = 0;
set @jval =1;
set @rstr = REVERSE(@str);
while (len(@rstr) >= 1)
begin
set @rchar = SUBSTRING(@rstr,1,1);
set @val = @val + (CHARINDEX(@rchar,@X36 COLLATE Latin1_General_CS_AS)-1)*@jval ;
set @rstr = SUBSTRING(@rstr,2,len(@rstr)-1);
set @jval = @jval * 36 ;
end
return @val;
END
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。