mssql中有一money类型,可以用来转换 declare @num INT set @num = 4564654 select replace(convert(varchar,cast(@num as money),1), '.00','') --4,564,654
mssql中有一money类型,可以用来转换 declare @num INT set @num = 4564654 select replace(convert(varchar,cast(@num as money),1), '.00','') --4,564,654