Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Update the first and last 2 charactors with year and month RE: Update the first and last 2 charactors with year and month

  • February 21, 2018 at 2:54 pm

    #1980699


    UPDATE [EC_StoreAttributes]

        SET AttributeValue = CONVERT(varchar(2), GETDATE(), 112) +
            SUBSTRING(AttributeValue, 3, LEN(AttributeValue) - 4) +
            CONVERT(varchar(2), GETDATE(), 3)

    WHERE
    AttributeType = 'ECSRCCODE' and StoreRecordId = '1'

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.