水的密度和温度的对照表 SQLServer库

最新推荐文章于 2024-11-06 20:49:14 发布

快乐withus

最新推荐文章于 2024-11-06 20:49:14 发布

阅读量637

点赞数 23

文章标签： sqlserver 数据库数据分析

本文链接：https://blog.csdn.net/qq_32594047/article/details/137035257

版权

本文展示了如何在SQLServer数据库中创建一个名为basWaterDensityWithTemp的表，用于存储不同温度下的水的密度和焓值数据。表包含温度、密度和焓值等字段，并插入了从1到100摄氏度的数据记录。

摘要由CSDN通过智能技术生成

if not exists (select 1 from sysobjects where name = ‘basWaterDensityWithTemp’)
create table basWaterDensityWithTemp
(
Id int identity,
Temp decimal(10,2) not null unique,
TUnit varchar(10) default ‘℃’,
Density decimal(13,4) not null,
DUnit varchar(10) default ‘kg/m3’,
WaterEnthalpy decimal(13,4),
EDUnit varchar(10) default ‘’
)
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 1,1000.2,4.7841
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 2,1000.2,8.9963
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 3,1000.2,13.206
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 4,1000.2,17.412
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 5,1000.2,21.616
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 6,1000.2,25.818
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 7,1000.1,30.018
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 8,1000.1,34.215
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 9,1000,38.411
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 10,999.94,42.605
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 11,999.84,46.798
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 12,999.74,50.989
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 13,999.61,55.178
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 14,999.48,59.367
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 15,999.34,63.554
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) select 16,999.18,67.74
insert into basWaterDensityWithTemp(Temp,Density,WaterEnthalpy) sel