sample55.sql

T-SQL示例大全

/* 文件名称: 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)