SQL Server 字符串截取、数据中字符转换、给字段求累计

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