sample55.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 14 行

/* 文件名称: Sample55.sql */

DECLARE @vlNumber1 real, @vlNumber2 real,
                  @vlNumber3 real, @vlNumber4 real
SET @vlNumber1 = 192830
SET @vlNumber2 = 1928300
SET @vlNumber3 = 1.79E + 308
SET @vlNumber4 = 3.40E + 38

SELECT CONVERT(varchar(6),@vlNumber1,0)
SELECT CONVERT(varchar(11),@vlNumber2,0)
SELECT CONVERT(varchar(14),@vlNumber3,1)
SELECT CONVERT(varchar(22),@vlNumber4,2)