随笔分类 -  SQL

摘要：有下面的一段原数据：KS_Date KS_MetalNameKS_TopLimitKS_BottomLimitKS_AverageKS_Change2011-12-14 00:00:00.000a1001055542011-12-14 00:00:00.000b11222011-12-14 00:00:00.000c111012011-12-14 00:00:00.000d11112011-12-14 00:00:00.000e11112011-12-14 00:00:00.000f11112011-12-14 00:00:00.000g11112011-12-15 00:00:00.00.. 阅读全文

摘要：SELECT KS_Date, KS_MetalName, KS_TopLimit, KS_BottomLimit, KS_Average, KS_ChangeFROM KS_U_SpotPriceWHERE (KS_Date BETWEEN CONVERT(datetime, '2011-12-14') AND CONVERT(datetime, '2011-12-20'))等效于下面的查询代码：SELECT KS_Date, KS_MetalName, KS_TopLimit, KS_BottomLimit, KS_Average, KS_Chang... 阅读全文