1.截取字符串并转换为int类型数据
SELECT convert(int,SUBSTRING ( gate_cd , 8 , 3 )) FROM [dbo].[WR_GATE_B]
2.字段中数据转换(sql server)
SELECT SEGT_CD, REPLACE(BEG_ADD,'+', '.') BEG_ADD, REPLACE(END_ADD,'+', '.') END_ADD FROM [dbo].[WR_SEGT_B]
3.时间字段修改(sql server)
UPDATE ST_RIVER_R SET tm=DATEADD(d,3,tm)
4.字段求累加(sql server)select
stcd,
stnm,
dt,
z,
(
SELECT
SUM(z)
FROM
(select a.stcd,b.stnm,CONVERT(VARCHAR(7),tm,120)DT,z
from T_BMBXMEASPOINT_R a
LEFT JOIN ST_STBPRP_B b on a.stcd=b.stcd WHERE CONVERT(VARCHAR(4),tm,120)=2019) AS test_table_1
WHERE
test_table_1.stcd = test_table_2.stcd and
test_table_1.dt <= test_table_2.dt
) AS grandz
FROM
(select a.stcd,b.stnm,CONVERT(VARCHAR(7),tm,120)DT,z
from T_BMBXMEASPOINT_R a
LEFT JOIN ST_STBPRP_B b on a.stcd=b.stcd WHERE CONVERT(VARCHAR(4),tm,120)=2019) AS test_table_2 ORDER BY stcd