SQL 16进制 转 10进制 ver2 (附建表/插值语句)

--建表语句：createtabletest_16to10(number16varchar(10)notnull);number16valueis:'D95B7D3C'--插值:insertintotest_16to10valus('D95B7D3C');--转换SQL：selectnumber16,substring(number16,1,1)a,substring(number16,2,1)b,substring(number16,3,1)c,substring(number16,4,1)d,substring(number16,5,1)e,substring