--函数
Create function fn_NumT(
@n numeric(28,6)
)
returns varchar(60)
as
begin
declare @x numeric(38,20)
declare @i int
set @i=0
set @x=@n
while @x>1
begin
set @i=@i+1
set @x=@x/10
end
while @x<1
begin
set @i=@i-1
set @x=@x*10
end
return cast(@x as varchar(60))+'e'+cast(@i as varchar(20))
end