34,594
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([aa] int,[bb] numeric(8,2),[cc] numeric(3,2))
insert [huang]
select 2950,414379.69,8.34
--------------开始查询--------------------------
SELECT CAST(CAST([aa] AS NUMERIC(19,9))/(CAST(cc AS NUMERIC(19,9))*CAST([bb] AS NUMERIC(19,9)))AS NUMERIC(19,9))
from [huang]
----------------结果----------------------------
/*
---------------------------------------
0.000853606
*/
----------------------------------------------------------------
-- Author :DBA_HuangZJ(發糞塗牆)
-- Date :2014-08-11 15:30:24
-- Version:
-- Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
-- May 14 2014 18:34:29
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
--
----------------------------------------------------------------
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([aa] int,[bb] numeric(8,2),[cc] numeric(3,2))
insert [huang]
select 2950,414379.69,8.34
--------------开始查询--------------------------
select * ,CAST([aa] AS NUMERIC(30,9))/(CAST(cc AS NUMERIC(30,9))*CAST([bb] AS NUMERIC(30,9)))
from [huang]
----------------结果----------------------------
/*
aa bb cc
----------- --------------------------------------- --------------------------------------- ---------------------------------------
2950 414379.69 8.34 0.00085360608
*/
----------------------------------------------------------------
-- Author :DBA_HuangZJ(發糞塗牆)
-- Date :2014-08-11 15:30:24
-- Version:
-- Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
-- May 14 2014 18:34:29
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
--
----------------------------------------------------------------
--> 测试数据:[huang]
if object_id('[huang]') is not null drop table [huang]
go
create table [huang]([aa] int,[bb] numeric(8,2),[cc] numeric(3,2))
insert [huang]
select 2950,414379.69,8.34
--------------开始查询--------------------------
select * ,CAST([aa] AS NUMERIC(30,9))/(CAST(cc AS NUMERIC(30,9))+CAST([bb] AS NUMERIC(30,9)))
from [huang]
----------------结果----------------------------
/*
aa bb cc
----------- --------------------------------------- --------------------------------------- ---------------------------------------
2950 414379.69 8.34 0.00711893
*/