CREATE FUNCTION [dbo].[tostr](@adc DECIMAL(18, 4))
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @ls_return VARCHAR(50)
SET @ls_return = CONVERT(CHAR(18), @adc)
WHILE substring(@ls_return, len(@ls_return), 1) = '0'
BEGIN
SET @ls_return = substring(@ls_return, 1, len(@ls_return) - 1)
END
RETURN @ls_return
END
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/75527/viewspace-723529/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/75527/viewspace-723529/